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

51 votes405 views6 answers
Installing mysql on ubuntu
SQL
2 votes201 views2 answers
How to DROP a table in mysql
SQL
49 votes198 views6 answers
Alter table add column
SQL
0 vote184 views1 answer
Sql server union if table exist
SQL
15 votes300 views2 answers
Sql order by alphabetical
SQL
6 votes192 views2 answers
Join vs union
SQL
0 vote197 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote189 views1 answer
Mysqlimport
SQL
1 vote183 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote195 views1 answer
Psql list view rules
SQL