insert into with select and multiple values in plsql code example
Example: add multiple row table pl sql
INSERT INTO real_table_name (person_id, given_name, family_name, title)
WITH temp_table AS (
SELECT 4, 'Ruth', 'Fox', 'Mrs' FROM dual UNION ALL
SELECT 5, 'Isabelle', 'Squirrel', 'Miss' FROM dual UNION ALL
SELECT 6, 'Justin', 'Frog', 'Master' FROM dual UNION ALL
SELECT 7, 'Lisa', 'Owl', 'Dr' FROM dual
)
SELECT * FROM temp_table