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

Question

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

Possible duplicate of [How can I confirm a database is Oracle & what version it is using SQL?](https://stackoverflow.com/questions/101184/how-can-i-confirm-a-database-is-oracle-what-version-it-is-using-sql) — Sam M, Apr 27 '18 at 05:05
Possible duplicate of https://serverfault.com/questions/171827/how-can-i-find-my-oracle-10g-server-version — Sam M, Apr 27 '18 at 05:06

score 5 · Answer 1 · answered Apr 27 '18 at 05:03

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;

score 3 · Accepted Answer · answered Apr 27 '18 at 02:52

3

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

select * from v$version

answered Apr 27 '18 at 02:52

danny

2 Answers2