Re: version awareness in sql script.

"DaLoverhino" <DaLoveRhino_at_hotmail.com> wrote in message 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?
:

select version from v$instance

not sure if it's also available via SYS_CONTEXT -- might check that out

++ mcs Received on Wed Mar 29 2006 - 20:19:29 CST