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 vote161 views1 answer
SQL Error 1040 : Too many connections
SQL
1 vote163 views1 answer
Oracle sql pad left zeros
SQL
0 vote148 views1 answer
Delete * from where id = 1;
SQL
0 vote155 views1 answer
Get primary key of table
SQL
5 votes161 views1 answer
Oracle drop index if exists
SQL
4 votes159 views1 answer
Adding data to table in sql python
SQL
0 vote165 views1 answer
Str_to_date sql server
SQL
0 vote153 views1 answer
Create-table-with-index-organization
SQL
1 vote161 views1 answer
Sql row having max
SQL
0 vote144 views2 answers
How do I install microsoft SQL on my Mac?
SQL