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:
DBMS_DB_VERSION:
I hope it helps!!
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
2 Responses to “How to find the Database version (DBMS_DB_VERSION)? Example.”
January 2, 2017 at 4:09 AM
That's good. You can also look into PL/SQL's conditional compilation.
May 10, 2023 at 4:48 AM
Lovvely post
Post a Comment