How to check the version of an Oracle database?

2 years ago
Liam
1 minute

There are multiple ways to view the version information of an Oracle database:

  1. Access the database server using the SQL*Plus command line interface. Open the command line interface and enter the following command.
sqlplus /nolog

Then connect to the database and execute the following command:

SELECT * FROM v$version;

This will display the version information of the database.

  1. Utilize the SQL Developer tool: Open the SQL Developer tool, connect to the database. Expand “Other Users” in the left navigation pane, then expand “SYS”, followed by “Tables”. Locate and double-click on the “V_$VERSION” table. In the right window, you can view the database’s version information.
  2. Connect to the database and execute the following commands using the data dictionary view:
SELECT * FROM v$version;

This will display the version information of the database.

No matter which method you use, you can obtain the version information of the database.

bannerAds