Re: WHILE EXISTS ....

In article <N4JKa.18557$Jw6.7560583_at_news1.news.adelphia.net>, Mail_at_NoSpamPlease.com says...
> 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
>
>
>

Closest thing would prolly be:

  for rec in (SELECT * FROM TABLE WHERE <Condition>) loop

• do something with rec.FIELD1, rec.FIELD2 etc.

  end loop;

• Tom