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

2 votes223 views1 answer
Column names in oracle sql
SQL
0 vote191 views1 answer
Exec procedure oracle
SQL
7 votes167 views1 answer
Mysql load data infile csv
SQL
0 vote208 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote213 views1 answer
Postgres change the name of schema
SQL
0 vote197 views1 answer
Select other columns with distinct
SQL
0 vote190 views1 answer
Mysql export and import
SQL
0 vote210 views1 answer
Use where instead of join
SQL
0 vote218 views1 answer
Alter owner in PostgreSQL
SQL
11 votes202 views2 answers
MySQL DISTINCT
SQL