How to check the version of an Oracle database

There are several ways to view the database version in Oracle.

1. Use the SQL*Plus command line tool:
2. Sign in to the command line interface of the database server and enter the following command:
3. Connect to the database as the system administrator.
4. This will log in to the database using the SYS user.
5. Please input the following command to check the database version:
6. Retrieve all rows from the view called “version”
7. This will display the version information of the database.
8. Utilize the SQL Developer graphical interface tool:
9. Open the SQL Developer tool and select the database connection from the connection list to view its version.
10. Type the following SQL statement in the “SQL Workspace” within the connection window.
11. Retrieve all information from the v$version table.
12. Next, click on the “execute” button to run the query and display the database version information.
13. Utilize database metadata views:
14. Use the following SQL statement to query the database version in SQL*Plus or SQL Developer:
15. Retrieve all records from the dba_registry table.
16. This will display the components and version information that are installed in the database.

You can view the version information of the Oracle database using any method.