Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Magazine Blooper
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 LabReceived on Mon May 10 2004 - 06:10:32 CDT
![]() |
![]() |