1INSERT INTO real_table_name (person_id, given_name, family_name, title)
2 WITH temp_table AS (
3 SELECT 4, 'Ruth', 'Fox', 'Mrs' FROM dual UNION ALL
4 SELECT 5, 'Isabelle', 'Squirrel', 'Miss' FROM dual UNION ALL
5 SELECT 6, 'Justin', 'Frog', 'Master' FROM dual UNION ALL
6 SELECT 7, 'Lisa', 'Owl', 'Dr' FROM dual
7 )
8 SELECT * FROM temp_table