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

3 votes306 views2 answers
Mysql user permission database
SQL
1 vote278 views2 answers
Get date from datetime postgresql
SQL
0 vote326 views2 answers
Unique key
SQL
4 votes314 views1 answer
Id increment ms sql server
SQL
0 vote305 views1 answer
MySQL import data from large CSV file
SQL
3 votes293 views1 answer
Oracle apex warning message
SQL
2 votes313 views2 answers
Postgres drop column if exists
SQL
5 votes305 views1 answer
Ora-00054 find lock
SQL
37 votes296 views3 answers
Postgresql insert column
SQL
1 vote299 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL