Re: sqlplus: loop until no updates

 	LOOP
 	    UPDATE ...;
 	    EXIT when sql%rowcount = 0;
 	END LOOP;

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ilia Bashtanov

iliab_at_mmc.ru

Hallvard B Furuseth <h.b.furuseth_at_usit.uio.no> wrote in article <HBF.97Apr1211139_at_bombur2.uio.no>...
> How do I do this?
>
> LOOP
> UPDATE ...;
> <EXIT if no changes in last update>;
> END LOOP;
>
>
> --
> Hallvard
>
  Received on Wed Apr 02 1997 - 00:00:00 CST