How to check which version of Oracle

[gurusamy sengodan]

How to check which version of Oracle installed on the machine?

[Mark Spritzler]

Client or Server, Windows or Linux/UNIX? On WIndows CLient, you can always go to START-PROGRAMS-ORACLE and look at one of the applications that are loaded by Oracle and check the Help menu of that program? Or something just like that. or command line sqlplus, that must have the Oracle version when you first log in.

Mark

[Avi Abrami]

select BANNER from V$VERSION

Good Luck,
Avi.

[Benjamin Lau]

How do I get the version from the code?

[Avi Abrami]

Benjamin,
Pardon my ignorance, but what code are you referring to?
.NET
java
C++
PL/SQL
other

Good Luck,
Avi.

[Benjamin Lau]

Avi,

java or PL/SQL

Thanks!

Benjamin

[Avi Abrami]

Benjamin,
Using PL/SQL:

declare
  V varchar2(64);
  S varchar2(320);
  cursor C is select BANNER from V$VERSION;
begin
  open C;
  loop
    exit when C%notfound;
    fetch C into V;
    S := concat(S, V);
  end loop;
  close C;
  DBMS_OUTPUT.PUT_LINE(S);
end;

With java, use the appropriate methods in the DatabaseMetaData interface.

Good Luck,
Avi.