InTheBeginning wrote:
> 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
Conditional compilation in 10g is accomplished using the built-in
DBMS_DB_VERSION package. There is a demo in Morgan's Library at
www.psoug.org and the package is documented at http://tahiti.oracle.com
and in $ORACLE_HOME/rdbms/admin/dbmsdbvn.sql.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jul 24 2006 - 22:45:14 CDT
