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

Similar codes

1 vote357 views2 answers
Regex starts with
SQL
14 votes362 views1 answer
Sql value of string
SQL
0 vote335 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote365 views1 answer
Mysql add text to existing field
SQL
2 votes382 views2 answers
Calculate percentage in sql
SQL
4 votes352 views1 answer
SQL find text in SP
SQL
0 vote423 views1 answer
Mysql dump for selected row
SQL
2 votes324 views2 answers
Function in sql
SQL
0 vote358 views1 answer
Sql count null values in all columns
SQL
0 vote353 views1 answer
Mysql foreach insert
SQL