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

1 vote209 views1 answer
Create temporal table in sql
SQL
0 vote217 views1 answer
Sql order by except one row
SQL
0 vote202 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote219 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote201 views1 answer
Exclude last comma separated string mysql
SQL
1 vote207 views1 answer
Search for tables with name postgresql
SQL
0 vote186 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote245 views1 answer
Check current sequence value postgres
SQL
2 votes287 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote198 views1 answer
Flask sqlalchemy. commit does not save changes
SQL