Re: And again: 1NF may not be dead
From: Tony Andrews <andrewst_at_onetel.com>
Date: 5 Nov 2004 09:58:33 -0800
Message-ID: <1099677513.153148.131630_at_c13g2000cwb.googlegroups.com>
Date: 5 Nov 2004 09:58:33 -0800
Message-ID: <1099677513.153148.131630_at_c13g2000cwb.googlegroups.com>
Oracle has this syntax in its procedural extension to SQL (PL/SQL):
FORALL i IN 1..ArrayExample.COUNT
INSERT INTO CHILDREN (parent_id,item_id)
SELECT 'X',ArrayExample(i);
I don't know whether standard SQL has an equivalent.
Received on Fri Nov 05 2004 - 18:58:33 CET