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 vote276 views2 answers
Uninstall postgresql mac
SQL
0 vote288 views1 answer
View t-sql mail configuration
SQL
1 vote270 views1 answer
Get last week data in mysql
SQL
0 vote286 views1 answer
Vs 2019 connect to local mysql database
SQL
2 votes309 views2 answers
Null column to 0 in mysql
SQL
-1 vote208 views3 answers
Ubuntu install mssql
SQL
0 vote344 views1 answer
Current month transactions in mysql
SQL
1 vote304 views2 answers
Drop table with constraints
SQL
0 vote286 views1 answer
Mariadb set vertical output format
SQL
0 vote260 views1 answer
Do postgresql
SQL