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 vote207 views1 answer
Add time to date sql
SQL
1 vote145 views1 answer
Oracle explain plan
SQL
0 vote170 views1 answer
SQL Server date literal
SQL
4 votes148 views1 answer
Sql any
SQL
0 vote155 views1 answer
Sql select maximum column with other columns returned
SQL
5 votes146 views1 answer
Postgres integer to serial
SQL
0 vote163 views1 answer
R write csv without index
SQL
1 vote185 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote173 views1 answer
How to get nth number in sql
SQL
1 vote151 views2 answers
Install mysqldump ubuntu
SQL