Serge Rielau wrote:
> See, whenever I see tehse constructs in migration I take the chain-saw
> to it:
>
> INSERT INTO loop_test
> WITH loop(i) AS (VALUES 999 UNION ALL
> SELECT i+1 FROM loop WHERE i < 1100)
> SELECT i FROM loop;
> COMMIT;
>
> so much more efficient (and presumably looks equaly elegant with CONNECT
> BY...)
> Just think about attached check constraints, triggers, RI, materialized
> view maintenance, ....
>
> But as you say. An example makes a point. One shall not over interprete
> it as a coding guideline.
>
> Cheers
> Serge
Perhaps, somehow, you missed the fact that this is
comp.databases.ORACLE. Your syntax might work somewhere. But Oracle
isn't going to be on that menu.
--
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 - 17:04:43 CDT
