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

0 vote357 views2 answers
Amazon linux postgresql client
SQL
3 votes330 views3 answers
How to add month in update sql
SQL
0 vote398 views1 answer
Split first name and last name in sql
SQL
1 vote307 views2 answers
Sql where keyword
SQL
0 vote325 views1 answer
Sql bild in function
SQL
0 vote318 views1 answer
Download mysql database to excel in android studio
SQL
4 votes356 views1 answer
Ms sql truncate table vs delete
SQL
0 vote338 views1 answer
Multiple like values for single column postgres
SQL
0 vote325 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote338 views1 answer
Change filed order in mysql
SQL