Re: version awareness in sql script.

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 30 Mar 2006 07:09:17 +0200
Message-ID: <442b67fc$0$5328$636a55ce@news.free.fr>

"DaLoverhino" <DaLoveRhino_at_hotmail.com> a écrit dans le message de news: 1143671383.228741.265170_at_i40g2000cwc.googlegroups.com...
| Hello. I have a simple script, but I want the script to alter it's
| behavior depending on whether it's being run against a 10, 9 or an 8
| instance. The patch level doesn't matter.
|
| I can use V$VERSION and parse the output:
| SQL> select * from v$version;
|
| BANNER
| ----------------------------------------------------------------
| Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
| PL/SQL Release 9.2.0.6.0 - Production
| CORE 9.2.0.6.0 Production
| TNS for Solaris: Version 9.2.0.6.0 - Production
| NLSRTL Version 9.2.0.6.0 - Production
|
|
| I would need to grab "Oracle9i", but I'm wondering if there's an easier
| way to do this?
|

dbms_utility.db_version

Regards
Michel Cadot Received on Wed Mar 29 2006 - 23:09:17 CST