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 vote104 views1 answer
Postgresql add leading zeros
SQL
16 votes152 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
39 votes237 views5 answers
Sql drop column
SQL
5 votes145 views1 answer
Mysql count newlines in field
SQL
3 votes131 views3 answers
Into in sql
SQL
0 vote127 views1 answer
Online sql testing tool
SQL
0 vote85 views1 answer
Psql not found windows
SQL
8 votes137 views1 answer
Oracle create datafile
SQL
0 vote137 views1 answer
Select last N rows mysql
SQL
6 votes140 views2 answers
Foreign key sqlite3 python
SQL