Thursday, 31 July 2008

Oracle version information

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:
Oracle10g Enterprise Edition Release - Production
PL/SQL Release - Production
CORE       Production
TNS for Solaris: Version - Production
NLSRTL Version - 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.