Re: sqlplus: loop until no updates

Hallvard B Furuseth wrote:
>
> How do I do this?
>
> LOOP
> UPDATE ...;
> <EXIT if no changes in last update>;
> END LOOP;
>
> --
> Hallvard
 

-- 

	LOOP
            UPDATE ... SET <colname> = value... 
	    WHERE .... <colname> != value;
        END LOOP;

Will exit after last update.