Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> WHILE EXISTS ....

WHILE EXISTS ....

From: Uma Muthu <Mail_at_NoSpamPlease.com>
Date: Thu, 26 Jun 2003 20:55:09 GMT
Message-ID: <N4JKa.18557$Jw6.7560583@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 Received on Thu Jun 26 2003 - 15:55:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US