version awareness in sql script.

From: DaLoverhino <DaLoveRhino_at_hotmail.com>
Date: 29 Mar 2006 14:29:43 -0800
Message-ID: <1143671383.228741.265170@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? Received on Wed Mar 29 2006 - 16:29:43 CST