Re: Oracle SQL 7.3, 8.0,8.1,8.1.7,9......

From: Ikarus <luciver_at_zone.at>
Date: Tue, 12 Feb 2002 22:43:07 GMT
Message-ID: <%Tga8.615657$5G5.4440212@news.chello.at>

You can use a dynamic SQL Script ??

REM =========================================

SET TERM OFF FEED OFF HEA OFF VER OFF TRIM ON SPOOL c:\temp\start.sql

SELECT decode(value,'8.1.X.X','script_a.sql'

                                    '7.2.X.X','script_b.sql')

FROM dual;

SPOOL off
sta c:\temp\start.sql

REM ============================================

This is only a simple example but it must work. Received on Tue Feb 12 2002 - 16:43:07 CST