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 vote249 views2 answers
Sql unique
SQL
1 vote197 views1 answer
Sql dcl
SQL
0 vote254 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote210 views1 answer
Horizontal join sqlite
SQL
0 vote219 views1 answer
.sql File Run in PSQL
SQL
1 vote195 views1 answer
Neo4j display all nodes and relationships
SQL
11 votes204 views2 answers
Safe mode off mysql
SQL
0 vote193 views2 answers
Sqlite unix timestamp
SQL
0 vote206 views3 answers
Query string not ending with with vowels
SQL
1 vote189 views1 answer
Regular expression in sql server
SQL