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 vote193 views1 answer
Kill slow queries mysql
SQL
11 votes182 views2 answers
Mysql set safe mode off
SQL
1 vote133 views1 answer
Full text index mysql
SQL
1 vote194 views1 answer
Db.Database.SqlQuery
SQL
0 vote190 views1 answer
Closure in sql
SQL
2 votes181 views1 answer
Postgresql add entry to table
SQL
0 vote174 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote144 views1 answer
Enable mysql slow query log
SQL
8 votes193 views1 answer
Oracle search stored procedures for text
SQL
1 vote177 views1 answer
Sql auto timestamp
SQL