using conditions in sql*plus

From: Jan Timmermans <jtimmerm_at_luc.ac.be>
Date: 1998/02/27
Message-ID: <6d6jlc$c1c$1@dalet.belnet.be>#1/1

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