Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Conditional define with PL/SQL

Conditional define with PL/SQL

From: InTheBeginning <n.montanaro_at_wanadoo.fr>
Date: 24 Jul 2006 01:34:16 -0700
Message-ID: <1153730056.278678.115520@s13g2000cwa.googlegroups.com>


Hi

Is it possible to have conditional define in pl/sql depending on Oracle version. ?

for example:

BEGIN
...

 IF_ORACLE_V9
   select ... from v$undostat
 ENDDEFINE;  IF_ORACLE_V8
   NULL;
 ENDDEFINE ;
...

END;   Thank you
Dan Received on Mon Jul 24 2006 - 03:34:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US