Oracle supports the concept of a nested table. You can insert data into a nested table as follows:
INSERT INTO TABLE(
SELECT p.nested_table
FROM primary_table p
WHERE p.user_id.id = 1)
VALUES ('1', 2, 3)
Oracle supports the concept of a nested table. You can insert data into a nested table as follows:
INSERT INTO TABLE(
SELECT p.nested_table
FROM primary_table p
WHERE p.user_id.id = 1)
VALUES ('1', 2, 3)