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 votes171 views1 answer
Check database name postgresql
SQL
0 vote175 views1 answer
Ansi sql count duplicate rows
SQL
3 votes158 views1 answer
Sql select all
SQL
2 votes167 views1 answer
Install sqlite npm
SQL
1 vote191 views1 answer
Oracle split string
SQL
2 votes206 views1 answer
Dbms transaction (psql)
SQL
0 vote174 views1 answer
Sqlite higher or equal
SQL
2 votes162 views1 answer
Sql alchemy or
SQL
0 vote172 views1 answer
Group by two columns postgres
SQL
0 vote182 views2 answers
Sql regex vowel
SQL