Re: WHILE EXISTS ....

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 26 Jun 2003 17:52:00 -0700
Message-ID: <92eeeff0.0306261652.427d07de@posting.google.com>

"Uma Muthu" <Mail_at_NoSpamPlease.com> wrote in message news:<N4JKa.18557$Jw6.7560583_at_news1.news.adelphia.net>...
> 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
Oracle is not Sql Server thus there are syntax differences between PL/SQL and T-Sql. Please don't try to cast PL/SQL as T-Sql... you won't get anywhere.

Lookup FOR and WHILE loops usage at http://tahiti.oracle.com. You will find plenty of different ways to use loops in a PL/SQL block... I am sure more then what you are used to in T-Sql.

Regards
/Rauf Sarwar Received on Thu Jun 26 2003 - 19:52:00 CDT