How to Know the Oracle Version
- 1). Open a terminal window in Unix or a command prompt window in Windows. The terminal window or command prompt will present you with a screen where you will type the following commands.
- 2). Type the command "sqlplus" to access the SQL Plus application. This application is used to send SQL queries to the Oracle server.
- 3). Type your user name and password when prompted. You will be presented with another command prompt that looks like "SQL>".
- 4). Type the command "select version from v$instance;" at the SQL command prompt. This command will return the version information of the Oracle database.
- 5). Type the command "quit" to exit the SQL Plus application.
Source...