Re: using conditions in SQL*PLUS

From: Mark Cudmore <mcudmore_at_kamloops.env.gov.bc.ca>
Date: 1998/02/27
Message-ID: <1998Feb27.092700.9964_at_vmsmail.gov.bc.ca>#1/1


Pick up a reference on PL/SQL. This is Oracle's version of SQL, and if includes control structures (looping, if..then..else)

I'm not sure how PL/SQL works in scripts as I have never tried it, but there should not be a problem

Mark Cudmore

Jan Timmermans wrote in message <6d6ju1$c4n$2_at_dalet.belnet.be>...
>Hi,
>
>to make changes in the definition of excisting tables, views, procedures
 and
>triggers we send sql scripts to our customers.
>These sql scripts can be executed from within sql*plus.
>The version of the tables is being stored in a special table VERSION.
>When an update script is executed we want to check whether the version
>of the tables is correct for that script. If not, the customer has to be
>notified
>and the script stops, if so the scripts continous normally.
>Problem : I can't find a way in sql*plus to excecute different code
>depending
>on a condition ( if then else ? ) or to stop an sql*script.
>Can anybody help me please !
>
>Thanx
>
>Jan
>
>
Received on Fri Feb 27 1998 - 00:00:00 CET

Original text of this message