How to check Oracle version from command line
We can running following command line
SQL> SELECT * FROM V$VERSION;
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
0
PL/SQL Release 12.1.0.1.0 - Production
0
CORE 12.1.0.1.0 Production
0
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
TNS for Linux: Version 12.1.0.1.0 - Production
0
NLSRTL Version 12.1.0.1.0 - Production
0
SQL>
Or
SQL> SELECT version FROM V$INSTANCE;
VERSION
-----------------
12.1.0.1.0
SQL>
Tidak ada komentar :
Posting Komentar