Total PageViews

Tuesday, July 23, 2019

How to check Oracle Database Version?


The below query will show the currently running version of Oracle Database

Query:- Select banner From V$version;

Suppose your currently running oracle database version is “12.2.0.1.0” then the nomenclature of oracle release numbers are shown below:-
12 -> Major Release Number
2 -> Database Maintenance release number
-> Application release number
1 -> Component specific release number
0 -> Platform-specific release number




No comments:

Post a Comment