Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: using conditions in sql*plus
use Pl/sql synthax to perform such operation
In article <6d6jpo$c4n$1_at_dalet.belnet.be>, "Jan Timmermans"
<jtimmerm_at_luc.ac.be> wrote:
>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
>
>
Nicolas
Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member
The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Sun Mar 01 1998 - 00:00:00 CST