Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Looping in SQL
In article <igZu6.109671$tP3.1704232_at_news1.rdc1.bc.home.com>,
bert_at_admicro.bc.ca says...
> I want to keep trying to alter a table until it is successful. If the alter
> table command is not successful, then try the alter command again. If it is
> not successul then do the next SQL command. I need to somehow check the SQL
> error code for alter command if it's OK or not. Can somebody tell me how to
> do this in SQL ??
As far as I know, there is no way to do this is straight SQL; you need a prcoedural language such as PL/SQL or perl.
Doug
-- ------------------- Douglas K. O'Leary Senior System Admin dkoleary_at_mediaone.netReceived on Sat Mar 24 2001 - 11:11:46 CST
![]() |
![]() |