How to determine the installed version of Oracle (Legacy KB ID CNC TS31652 )

Document ID : KB000051940
Last Modified Date : 14/02/2018
Show Technical Document Details
In order to check the version of Oracle from command line, you can run: sqlplus -V


Example:      sqlplus -V
     SQL*Plus: Release 9.2.0.3.0 - Production


In order to see version information about Oracle using nhisql, please run the following commands:



UNIX: 
        $NH_HOME/bin/sys/nhisql 'select * from v$version;'


WINDOWS:
        %NH_HOME%\bin\sys\nhisql 'select * from v$version;'


In order to check the Oracle version while in an SQL*PLUS session, use the following query: 
      select * from v$version; 



Related Issues/Questions:
How to determine the installed version of Oracle
Which Oracle revision am I running
Command to use to check Oracle version

Problem Environment:
eHealth
Oracle


(Legacy KB ID CNC TS31652 )