Re: WHILE EXISTS ....

Uma Muthu wrote:

> Is there any easy way to use WHILE EXISTS in
> PL/SQL like T-SQL (See below).
>
> Any help would be grateful.
>
> TIA,
> Uma
>
> WHILE EXISTS (SELECT * FROM TABLE WHERE <Condition>)
>
> BEGIN
> SOME STUFF ....
> END
No. And the syntax is preposterous. A loop requires PL/SQL and in PL/SQL you must select into some thing.

Use a cursor or bulk bind.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)