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

5 votes229 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote168 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote202 views1 answer
Download sql file of countries names
SQL
0 vote184 views1 answer
Procedures sql insert mysql
SQL
0 vote186 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote177 views1 answer
Min mysql
SQL
15 votes179 views2 answers
Open postgress in terminal mac
SQL
0 vote191 views1 answer
How to join result table in mysql
SQL
0 vote178 views1 answer
Alter table engine mysql
SQL
0 vote189 views1 answer
Import Data in MySQL without using any other software
SQL