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.




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.

Byrd Nick said...
May 10, 2023 at 4:48 AM

Lovvely post

Post a Comment


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.