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 votes164 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote165 views2 answers
Update all columns in one update
SQL
0 vote182 views1 answer
Sql server union if table exist
SQL
3 votes189 views1 answer
Force using index oracle
SQL
0 vote159 views3 answers
Sql all columns
SQL
1 vote185 views1 answer
Get parameter value in mysql trigger
SQL
4 votes158 views1 answer
Oracle table statistics last analyzed
SQL
0 vote165 views1 answer
Postgresql like
SQL
0 vote203 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote158 views1 answer
Order by oracle
SQL