Oracle / PLSQL: Checking Oracle Version Information

This post explains how to check Oracle version information running on Linux and windows.

Description

You can check Oracle version using SQL plus query. Oracle database could be running on Linux and windows and we can simply find out version information from v$version view from SQL Developer or SQL Plus command prompt.

Query to check Oracle Version

There are many ways to check database version. You can use anyone method to get the result.

Connect to SQL*Plus it will show you the database version.

Retrieve Oracle Version information
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION VERSION_FULL STATUS

Oracle Database 19c Enterprise Edition 19.0.0.0.0 19.6.0.0.0 Production
SQL> SELECT * FROM v$version;
BANNER
BANNER_FULL
BANNER_LEGACY CON_ID

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 0

Conclusion: If you are checking what Oracle Version you are running then you can use above query which will show you the correct database version running on Linux or windows.