Re: Oracle Magazine Blooper

From: Serge Rielau <srielau_at_ca.eye-be-em.com>
Date: Mon, 10 May 2004 07:10:32 -0400
Message-ID: <c7nnvq$2lp$1@hanover.torolab.ibm.com>

I didn't miss that and I stated CONNECT BY as the Oracle way of doing it, presuming soemone knows how to translate. Unfortunetely I neither have CONNECT BY experience, nor (obviously) an Oracle system to try it.

The point I tried to make however is simple enough: If there is a way to pull the INSERT out of the loop then that would be better coding style. The means used (varray, table function, recursion, ..?) are secondary.
If it can't be done I withdraw my example :-)

BTW, doesn't Oracle support a FOR loop which "blocks" the body and pushed the whole beast deeper into the engine? That as well would be better :-)

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Received on Mon May 10 2004 - 06:10:32 CDT