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

5 votes33 views3 answers
Postgres show databases
SQL
19 votes39 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
3 votes41 views1 answer
Oracle undo tablespace schema
SQL
2 votes36 views2 answers
Postgresql search all tables for column name
SQL
0 vote27 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote28 views1 answer
Sql dcl
SQL
0 vote31 views1 answer
Mysql insert into select transaction c#
SQL
0 vote33 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote35 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote30 views1 answer
Sql not equal multiple columns
SQL