How to Know the Oracle Version


It is important to know the exact version of the software that you are using when performing updates or when distributing applications to multiple sites and servers. The Oracle database contains a set of tables that contain the system statistics. These tables begin with the "V$" designation and are called the dynamic performance tables. The table that contains the version information for the Oracle software is the "V$instance" table. It also contains information such as the host name, status and startup time for the database server.

Things You'll Need

  • Oracle
  • 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.

  • Type the command "sqlplus" to access the SQL Plus application. This application is used to send SQL queries to the Oracle server.

  • Type your user name and password when prompted. You will be presented with another command prompt that looks like "SQL>".

  • Type the command "select version from v$instance;" at the SQL command prompt. This command will return the version information of the Oracle database.

  • Type the command "quit" to exit the SQL Plus application.


Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!