Unable to get version of Oracle database

Question

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.

The statement is fine. To me it looks like this Aqua Studio thing messes with your statement. — , Oct 13 '15 at 08:50
If the Aqua Data Studio issue is resolved, can you mark as the accepted answer ? — tariq, Oct 17 '15 at 21:07
I'm sorry, I've checked correct answer but it's been deleted. I'm going to verify your answer soon. — Arkadiusz Kałkus, Oct 18 '15 at 07:47

score 1 · Accepted Answer · answered Oct 15 '15 at 19:14

1

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

answered Oct 15 '15 at 19:14

tariq

score 0 · Answer 2 · answered Oct 13 '15 at 08:51

0

You can try SELECT * FROM PRODUCT_COMPONENT_VERSION;

answered Oct 13 '15 at 08:51

Chaitanya Kotha

2 Answers2