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

2 votes115 views1 answer
Q operator in sql
SQL
4 votes123 views2 answers
Oracle last day of month
SQL
0 vote116 views1 answer
Mysql show foreign keys column
SQL
3 votes127 views1 answer
Oracle function return
SQL
0 vote115 views2 answers
Mysql disable foreign key checks
SQL
1 vote129 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote136 views2 answers
How covert into int in maria db
SQL
0 vote123 views1 answer
Oracle character index
SQL
0 vote113 views1 answer
Sql revert migration
SQL
16 votes125 views4 answers
Ascending order mysql
SQL