Re: WHILE EXISTS ....

Daniel Morgan (damorgan_at_exxesolutions.com) wrote:
: Malcolm Dew-Jones wrote:

: > 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.

: I answered your question. You chose to snip that part. I'd suggest a
: re-read.

How could you have answered my question when I didn't have a question? What Daniel Morgan wrote =~ m/\. (.*\.)$/s; "$1" Received on Fri Jun 27 2003 - 14:52:59 CDT