Wednesday, 31 October 2012

Oracle Database Version

Ever wondered what Oracle database version you are running on, use the following query

Oracle Version :
-----
select * from v$version
where banner like 'Oracle%';

v$version also have versions for PL/SQL version and TNS version etc.
-
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Integrations Lead - Lessons learnt

 Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...