Re: How to find Oracle Version?

From: Stephen Harris <sweh_at_mpn.com>
Date: 8 Jun 1999 09:22:31 GMT
Message-ID: <7jincn$m06$1@nebula.mpn.com>

Valent Levente (valentl_at_szabinet.hu) wrote: : The v$version might contain irrelevant version information. : use sm$version, instead :

No - do not use sm$version because it is not always (at all?) correct.

> select * from sm$version;

   VERSION_T VERSION_NUMBER CREATED

• -------------- --------- 7.3.2.0.0 120594432 25-MAR-99

> select * from v$version where banner like 'Oracle%';

   BANNER

---

   Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production

Interesting...

/oracle/app/oracle/product/8.0.5/rdbms/admin/catsvrmg.sql includes the lines

   create or replace view sys.sm_$version as

       select '7.3.2.0.0' version_text, 120594432 version_number, created
       from sys.dba_objects where owner = 'SYS' and object_name = 'SM_$VERSION';

   grant select on sys.sm_$version to public;    drop public synonym sm$version;
   create public synonym sm$version for sys.sm_$version;

I don't think you can trust this for anything :-)

--

rgds
Stephen Received on Tue Jun 08 1999 - 04:22:31 CDT