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 vote142 views1 answer
Mysql show queries running
SQL
1 vote159 views1 answer
Sql and
SQL
65 votes323 views6 answers
Sql add column to table
SQL
0 vote131 views1 answer
Mysql change default collation
SQL
8 votes125 views2 answers
Phpmyadmin password
SQL
1 vote131 views1 answer
Mysql select month and year
SQL
0 vote210 views1 answer
Mysql disable triggers
SQL
0 vote154 views1 answer
Delete a record from a table sqlite3
SQL
1 vote122 views1 answer
What is int in mysql
SQL
1 vote141 views1 answer
Sql server epoch to datetime
SQL