SQL*Plus is poor for such things. Use PL/SQL. (it could be made with
SQL*Plus though with multiple effort)
Jan Timmermans <jtimmerm_at_luc.ac.be> wrote in article
<6d6jlc$c1c$1_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 Mon Jun 15 1998 - 09:18:59 CDT
