Re: WHILE EXISTS ....

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 27 Jun 2003 00:27:19 -0800
Message-ID: <3efbf1d7@news.victoria.tc.ca>

Daniel Morgan (damorgan_at_exxesolutions.com) wrote:
: 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.

No it isn't oracle syntax, but how is it preposterous?

While a condition is true, do something;

It looks a lot like pascal to me. Received on Fri Jun 27 2003 - 03:27:19 CDT