Friday, April 25, 2014

oracle database find version

When you open an SR with Oracle Support you must answer a lot of embarassing questions, like "Database/Version".
Open a connection with SQLDeveloper and run "SELECT * FROM V$VERSION;"
This is what you get:
Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
"CORE Production"
TNS for IBM/AIX RISC System/6000: Version - Production
NLSRTL Version - Production

No comments: