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 vote166 views1 answer
Find size of all DB's postgres
SQL
-1 vote122 views1 answer
Mysql order by on condition
SQL
0 vote122 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote118 views1 answer
Sql menampilkan data tabel
SQL
0 vote142 views1 answer
Check if mysql db is used
SQL
1 vote125 views2 answers
Change table name phpmyadmin
SQL
0 vote123 views1 answer
Postgresql remove new line from string
SQL
0 vote114 views1 answer
Oracle DROP PROGRAM
SQL
1 vote144 views1 answer
Mysql find tables with column name
SQL
0 vote125 views1 answer
Get null value in sql
SQL