How to Get Oracle DB Version

I only know two ways of getting the Oracle DB version you are currently connected to. They are as follows:


SELECT *
FROM product_component_version



SELECT *
FROM v$version


This is quite handy if your program has SQL commands that are not applicable for earlier versions of Oracle Database.

Incoming search terms:

• get oracle version
• oracle select db version
• select dbversion

Related posts:

1. How To Determine SQL Server Version
2. Monitor Oracle DB Server Processes
3. Select Random Records in Oracle