web analytics
How to check which version of Oracle database is installed? Options
codeling
Posted: Saturday, January 30, 2016 3:17:03 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 738
Points: 3102

To identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary view PRODUCT_COMPONENT_VERSION. A sample query follows. (You can also query the V$VERSION view to see component-level information.) Other product release levels may increment independent of the database server.

SELECT * FROM PRODUCT_COMPONENT_VERSION;

Product     				Version      Status
NLSRTL      				12.1.0.2.0   Production
Oracle Database 12c Enterprise Edition  12.1.0.2.0   64bit Production
PL/SQL      				12.1.0.2.0   Production
TNS for 64-bit Windows:    		12.1.0.2.0   Production
Sponsor
Posted: Saturday, January 30, 2016 3:17:03 PM
 
Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.