CODEWITHSUNDEEP
sqloracle-databaseversion
Vy Do
Vy Do

Reputation: 52488

How to get Oracle database version?

How to get Oracle database version from sqlplus, Oracle SQL developer, SQL Navigator or other IDE?

Upvotes: 9

Views: 16219

Answers (3)

Kaleemullah
Kaleemullah

Reputation: 534

Soultion:

Used this command SELECT * FROM V$VERSION It will show detail about oracle version in the SQL Developer.

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE   11.2.0.4.0  Production"
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Upvotes: 1

Vy Do
Vy Do

Reputation: 52488

Execute this statement from SQL*Plus, SQLcl, Oracle SQL Developer, SQL Navigator or other IDE:

select * from product_component_version

And you'll get:

PRODUCT                                VERSION    VERSION_FULL STATUS
-------------------------------------- ---------- ------------ ----------
Oracle Database 18c Enterprise Edition 18.0.0.0.0 18.3.0.0.0   Production

Upvotes: 16

Yaron Idan
Yaron Idan

Reputation: 6765

Try running this query in SQLPLUS - 

select * from v$version

Upvotes: 16

Related Questions