Total Pageviews

Monday, September 1, 2014

checking database version in oracle thru sql command


Run any of these command to check database version after login to sqlplus

$sqlplus

$ / as sysdba


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;
 
 

No comments:

Post a Comment