CODEWITHSUNDEEP
oracle-databasetoad
danny
danny

Reputation: 457

How to find oracle's version I connected with toad?

Like title says, I want to know oracle's version I connected with toad.

Upvotes: 1

Views: 11330

Answers (2)

Sam M
Sam M

Reputation: 4166

If you don't have access to v$version or v$instance, you can run this code. Be sure to turn on DBMS Output.

BEGIN 
   DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); 
END;

You can also run select * from PRODUCT_COMPONENT_VERSION;

Upvotes: 5

danny
danny

Reputation: 457

We could use this query command to find oracle's version.

select * from v$version

enter image description here

Upvotes: 3

Related Questions