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