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.
Tuesday, March 17, 2009
Subscribe to:
Comments (Atom)