Unable to get version of Oracle database

472 Views Asked by At

Finding version of Oracle database should be easy. As written here: How can I confirm a database is Oracle & what version it is using SQL? it's one command:

select * from v$version;

However it seems to be not working on some specific versions of Oracle. My database throws following exception while executing the command:

[Error] Script lines: 1-1 -------------------------- ORA-00911: invalid character Script line 1, statement line 1, column 23

I use Aqua Data Studio 15.0.14 to connect with DBMS.

2

There are 2 best solutions below

0
On BEST ANSWER

select * from v$version
go
Aqua Data Studio uses go or / as statement separator. You can change this behavior under File-> Options.

0
On

You can try SELECT * FROM PRODUCT_COMPONENT_VERSION;