Re: WHILE EXISTS ....

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

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

: I'm on the line between ignoring this as rubbish and responding so ...
: with that in mind ...

: You wrote:
: "but how is it preposterous?"

: Please note the question mark at the end. That, in the English language,
: signifies that
: a question has been asked.

And the fact that my question quoted above was posted several messages *after* your answer doesn't bother you?

I asked

        "how is it [the displayed syntax] preposterous?"

To which you presciently answered, several messages earlier,

	"A loop requires PL/SQL and in PL/SQL you must select into some
	thing.  Use a cursor or bulk bind."

So I have another question, how did people program loops before PL/SQL was around? Which is just another way of asking my original question, in what way was the original syntax "preposterous"? Are you suggesting that every language other than PL/SQL is a preposterous language?

: My statement was that the answer to the question was snipped from my
: previous post.

: Now having thinly spread angst all over the internet I will ignore this
: thread henceforth.

I repeat, with a minor update and bug fix

        What Daniel Morgan wrote (earlier) =~ m/.*\. (.*\.)$/s; "$1" Received on Sat Jun 28 2003 - 02:51:12 CDT