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

0 vote292 views1 answer
Allow external access to mysql
SQL
0 vote285 views1 answer
Except in sql
SQL
0 vote304 views1 answer
SQL SERVER xquery count child nodes
SQL
4 votes280 views1 answer
Mysql ip address
SQL
0 vote275 views2 answers
Cascade syntax in sql
SQL
0 vote304 views1 answer
What is top n result in sql
SQL
23 votes327 views5 answers
Sql substring
SQL
0 vote279 views1 answer
Sql query to delete row by id
SQL
14 votes292 views3 answers
Sql trim from string
SQL
0 vote289 views2 answers
How to list all values of a column that start with a letter in sql
SQL