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 vote333 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote344 views1 answer
Postgres sequence name
SQL
0 vote413 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote319 views1 answer
Mysql update sequence with order by
SQL
0 vote375 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote356 views1 answer
Copy data from one postgres container to another
SQL
0 vote395 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote326 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote315 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote370 views1 answer
How to fetch data from database in sql
SQL