Sunday, October 11, 2015

how to know the Oracle database version

you can use

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;
 
Yasser 

No comments:

Post a Comment