Re: Oracle Magazine Blooper

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 09 May 2004 07:31:54 -0700
Message-ID: <1084113115.36012@yasure>

Serge Rielau wrote:

> In defense of examples it always depends on what you want to show.
> I for one find it very hard to find examples that show consicely how a
> given feature works and at the same time make sense and are good style.
> E.g. a good way to explain a WHILE loop is to code a SUM or COUNT, but
> who in his right mind would do that proceduraly?
>
> Cheers
> Serge
>

The demo I use is:

DECLARE i PLS_INTEGER := 999;

BEGIN
   WHILE i < 1100
   LOOP

     i := i + 1;
     INSERT INTO loop_test VALUES (i);

   END LOOP;
   COMMIT;
END;
/

I think it makes the point.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sun May 09 2004 - 09:31:54 CDT