How to get Oracle server version (PL/SQL version,) in PL/SQL procedure

[vlvlad]

Hi,
Dependently from Oracle version I have to execute different code. Something like:

version := get_oracle_version();
if version = '7.3.4' then
<Oracle 7.3.4 code>
end if;

if version = '8.*.*' then
<Oracle 8.* code>
end if;


The question is: how to get oracle version?

Best regards,
Vovik

 

[vikramkalsi]

Check out thread186-264726 for oracle version info.

Regards,
-Vikram.