When making support requests it is always helpful to include version information about the product in question. Rather than just stating ‘version X’ I like to get the software to display the version information and just copy and paste it – this way there can be no confusion, and there may even be extra useful information.
So, how to display the oracle version information? I came across this useful post which suggests:
select banner from v$version;
which on the instance I’m looking at produces:
BANNER---------------------------------------------------------------- Oracle10g Enterprise Edition Release 10.2.0.3.0 - Production PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for Solaris: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production
Being an SQL query is even more useful than a command line, since you can run this within your applications if you need to display such data.
