web analytics
How to check the Oracle database version? Options
codeling
Posted: Monday, March 13, 2017 9:06:28 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 892
Points: 3738

To get detailed version number of the database components, you can try:

SELECT * FROM V$VERSION

or

SELECT version FROM V$INSTANCE

or

BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;

 

Sponsor
Posted: Monday, March 13, 2017 9:06:28 AM
 
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.