Re: Help SQLPLUS
From: Charlie Edwards <Charlie3101_at_hotmail.com>
Date: 12 Jun 2002 02:04:55 -0700
Message-ID: <db479d88.0206120104.3a574243_at_posting.google.com>
Date: 12 Jun 2002 02:04:55 -0700
Message-ID: <db479d88.0206120104.3a574243_at_posting.google.com>
franck lejeune <flejeune_at_etu.utc.fr> wrote in message news:<Pine.OSF.4.33.0206111825410.12677-100000_at_vega.utc.fr>...
> Hi,
>
> I have to write only in SQLPLUS a script which insert a row in a table
> only if a test is ok, but I don't know how to do this...
>
> In PL/SQL it is possible with the statement if then else but How can I do
> with only SQLPlus ?????
>
> Thanks
>
> Franck.
You don't want to use PL/SQL???
What version of Oracle are you running? 5???
It does depend on what sort of test it is. If you can build a test to generate an Oracle error you could use the 'WHENEVER SQLERROR' construct
CE Received on Wed Jun 12 2002 - 11:04:55 CEST