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