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

6 votes339 views2 answers
Postgresql database url
SQL
1 vote302 views1 answer
Oracle sql create or replace view
SQL
0 vote334 views1 answer
The package java.sql is not accessible
SQL
0 vote326 views1 answer
How to search query in python3 sqlite3
SQL
1 vote307 views2 answers
Mysql type conversion
SQL
0 vote344 views1 answer
Add created and updatedAt fields in mysql
SQL
2 votes314 views1 answer
Oracle convert run_duration to number
SQL
0 vote303 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
11 votes320 views3 answers
Change column name sql server management studio
SQL
8 votes276 views1 answer
Similarities between ddl and dml
SQL