How to Check the Oracle Version

How to check the Oracle version?

You can check the Oracle version you are connected to by retrieving information from the v$version data dictionary view

v$version has only one field, BANNER.


select * from v$version


1 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
2 PL/SQL Release 10.2.0.4.0 - Production
...
...

Aside from the Oracle version, you can also retrieve version information of other oracle related products, like Pl/SQL etc.