NESTED TABLE INSERTS only on non null?

I would like to be able to do:

INSERT INTO TABLE(SELECT EXAMPLE_NESTED_TABLE from PARENT_TABLE WHERE ID='1') VALUES (...) for lots of data, but the select returns null initially, which means I have to make a special case out of the first entry going into the nested table.

I can do this with some more coding, but would rather be able to treat all additions the same. Is there anything I can do to avoid doing:

UPDATE TABLE SET EXAMPLE_NESTED_TABLE=NESTED_TYPE('1st entry') WHERE ID='1';

I guess I could insert the first row into the nested table when the pk ID is first inserted.

please let me know if there are any other approaches.

Job Miller Received on Tue Nov 20 2001 - 17:36:32 CET