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

4 votes147 views2 answers
Postgresql default value
SQL
1 vote170 views1 answer
Sql server read uncommitted
SQL
5 votes136 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote136 views1 answer
Oracle index hint
SQL
0 vote142 views1 answer
Get only one row in mysql
SQL
1 vote157 views2 answers
Drop table if exists test
SQL
0 vote153 views1 answer
How to create a table in sql stack overflow
SQL
0 vote149 views1 answer
Create database like
SQL
0 vote134 views1 answer
Xampp mysql version
SQL
1 vote145 views1 answer
Sql try catch
SQL