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 votes140 views1 answer
Oracle kill job by sid
SQL
1 vote161 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
11 votes160 views2 answers
How to import mysql database command line
SQL
13 votes144 views4 answers
Mysql select last 10 rows
SQL
0 vote153 views1 answer
Mysql query problems and solutions
SQL
7 votes145 views2 answers
Add column table pl sql
SQL
0 vote147 views1 answer
Limit and offset in stored procedure mssql
SQL
24 votes173 views4 answers
Delete db postgres
SQL
0 vote152 views1 answer
Get record which is available in one table but not in another mysql
SQL
2 votes140 views1 answer
Sql like variable
SQL