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 vote198 views1 answer
Select tables with name like mysql
SQL
0 vote184 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes248 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote198 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
3 votes186 views4 answers
Order by desc postgres
SQL
9 votes246 views6 answers
Replace sql
SQL
0 vote199 views1 answer
Less than and between in sql query
SQL
0 vote190 views1 answer
Normalization in database 2nd normal form
SQL
3 votes188 views1 answer
Oracle wait
SQL
0 vote190 views1 answer
Char varchar nvarchar sql
SQL