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 vote172 views1 answer
Mysql update table from select on another table
SQL
1 vote98 views1 answer
What is int in mysql
SQL
0 vote101 views1 answer
Mysql drop multiple tables at once
SQL
0 vote115 views1 answer
Download sql file of countries names
SQL
3 votes101 views1 answer
Oracle revoke
SQL
0 vote117 views1 answer
Mql5 datetime get hour
SQL
1 vote111 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
1 vote114 views1 answer
Raw query must include primary key
SQL
0 vote129 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote107 views1 answer
Psql datetime grather than
SQL