Oracle is a relational database management system by Oracle Corporation
It is one of the most widely used databases in OL TP Data Warehouse
Oracle released a good number of versions since 1979. And the latest version is 19 C which is available for on premise as well as
in the cloud
Many of the users are still using 11 g, 12 c and 18 c
So let's f which version of the database you are running
before that? Let's understand the database release number format used by oracle
oracle. Database release number format
internally. Oracle maintains versions as five numeric segments, 20 X X X X divided by periods
E G for 10 G version could be 10.1 dot 0.1 dot zero or 10.1 dot 0.1 dot one
meaning of each segment. First numeral major database release number E G 12 C 18 C
2nd numeral database maintenance release number 3rd numeral application server release number 4th numeral component specific
release number
5th Numeral Platform Specific Release Number. Finding out the oracle version
oracle maintains version information in version product underscore component underscore version data
dictionary views or metadata table
Just run a query against these views to find out the database version
version, version numbers of core library components in the oracle database product underscore component underscore version version and status information
for component products
Sequel query. To get data base version
you can run on sequel plus or just copy query and run on sequel developer query
One call banner format, a 200 call con underscore I D format 99 select from version banner con underscore I D dash oracle database 10
g enterprise edition release 10.1 dot 0.1 dot 0 to 64 bit production zero pl slash sequel release 10.1 dot 0.1 dot zero
production zero core 10.1 dot zero 0.1 dot zero, production zero, TNS for Linux version 10.1 dot 0.1 dot zero
production zero N L S R T L version 10.1 dot 0.1 dot zero
production zero query to call product format A 50 call version format
a 20 call status format. A 40 select from product underscore component underscore version, product version status
an L S R T L 10.1 dot 0.1 dot zero production oracle database 10 g enterprise edition 10.1 dot 0.1 dot 0
64 bit production pl slash sequel 10.1 dot 0.1 dot zero, production TNS for Linux 10.1 dot 0.1 dot zero production
The output of the above query is 10.1 dot 0.1 dot zero
That means you are running 10G version
use D B M S underscore utility dot DB underscore version package to check oracle version
Another method is using D B M S underscore utility dot DB underscore version package available in the database
It is PL slash sequel package. So you need to run the below script to get version information
D B M S underscore utility dot DB underscore version returns version and compatibility information
pl slash sequel script to get DB version in oracle, declare V one bar chart to 100 V two bar chart to 100 begin D
B M S underscore utility dot DB underscore version V one V two D B M S underscore output dot Put underscore line version vertical
bar V one D B M S underscore output dot Put underscore line compatibility
vertical bar V two and output version 19.0 dot 0.0 dot zero
compatibility 19.0 dot zero. It is 19 c
summary
Knowing the version information is useful when you open a support request or when a patch needs to be applied
It also helps developers to understand the features available in the release
I hope you found this small article helpful
Please share and subscribe dot reference oracle 11 G database administrators guide