Sunday, January 1, 2017

How to find the Database version (DBMS_DB_VERSION)? Example.













I use to work in multiple database versions. Further, i use to have  my own utility packages which i use for collecting various stats, doing code review etc. But, the major problem i face is building a common utility which can be compiled in different oracle database versions.  Especially, in a database like Oracle, where every version adds more suprises and features.

So, the anonymous block which i build for preparing the utility uses a standard oracle utility named “DBMS_DB_VERSION”. Its a very useful one to check the version of the database and proceed. Below is the sample example.

V$VERSION:

image

DBMS_DB_VERSION:

image
I hope it helps!!

2 Responses to “How to find the Database version (DBMS_DB_VERSION)? Example.”

Michael Coughlin said...
January 2, 2017 at 4:09 AM

That's good. You can also look into PL/SQL's conditional compilation.


oraclefusion said...
March 15, 2017 at 3:47 AM

Thanks for sharing the good information for more information about the oracle visit
Oracle Fusion Financials Training


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.