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 vote338 views1 answer
Mysql where in keep order
SQL
0 vote326 views1 answer
Example of sql querry result sepapreted by comma
SQL
-1 vote264 views1 answer
Mysql how to set update or create
SQL
0 vote331 views1 answer
Oracle SQL join three tables and group by column
SQL
-2 votes318 views1 answer
Create trigger syntax
SQL
0 vote346 views1 answer
How to get nth number in sql
SQL
1 vote358 views1 answer
Dropping a constraint in ms sql
SQL
1 vote368 views3 answers
Read all columns of a table sql
SQL
0 vote367 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote354 views1 answer
Mysql query with sql to get the next row
SQL