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 vote144 views1 answer
Drop unique
SQL
50 votes224 views6 answers
Install mysql on ubuntu
SQL
0 vote153 views2 answers
Mysql row_number() example
SQL
0 vote123 views1 answer
Mysql concat and use as where column
SQL
2 votes138 views1 answer
Add default sql server
SQL
0 vote91 views1 answer
How to check oracle index table
SQL
1 vote140 views2 answers
Mysql remove first and last character from string
SQL
3 votes139 views2 answers
Get current year sql
SQL
7 votes150 views2 answers
Postgres concat
SQL
0 vote133 views4 answers
User defined function sql
SQL