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

Products

• CA eHealth

Issue/Introduction

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 )

Environment

Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
Component: