Oracle : Inserting into nested tables

Created 12 October 2005 00:00
INSERT INTO TABLE(
  SELECT p.nested_table
  FROM primary_table p
  WHERE p.user_id.id = 1)
VALUES ('1', 2, 3)