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

8 votes368 views2 answers
Replace string value in sql
SQL
0 vote336 views2 answers
T SQl Checking Your Username
SQL
3 votes349 views3 answers
C# sql select
SQL
0 vote343 views1 answer
Check duplicate values plsql
SQL
0 vote360 views1 answer
Oracle tablespace autoextend
SQL
0 vote318 views1 answer
Sqlite3 not commit
SQL
1 vote344 views1 answer
Simple project for database
SQL
0 vote394 views1 answer
Python mysql check if database exists
SQL
5 votes327 views1 answer
Oracle ora-00054 causes
SQL
1 vote384 views1 answer
Alter constraint in sql
SQL