Re: And again: 1NF may not be dead

Tony Andrews wrote:

> 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.

no good, you have a procedural loop. The OP is a wishlist item, so it gets to stay pure. The pure expression is a single command that inserts the entire array in one smack.

It does what you mean, perl-style.

-- 
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me