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

1 vote224 views1 answer
Oracle boolean to varchar
SQL
0 vote269 views1 answer
Insert array into mysql column
SQL
14 votes290 views1 answer
Oracle alter table add column not null
SQL
0 vote226 views1 answer
Mysqli or pdo
SQL
4 votes258 views1 answer
Mysql ip address
SQL
2 votes258 views1 answer
Select * from table where name like
SQL
3 votes260 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote305 views2 answers
Insert data mysql with cmd
SQL
0 vote274 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
2 votes288 views2 answers
Mysql write into table
SQL