Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> using conditions in sql*plus
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 CST