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 vote365 views1 answer
Désinstaller postgresql linux
SQL
0 vote339 views1 answer
AddEntityFrameworkSqlite
SQL
2 votes352 views1 answer
Mariadb select multiple rows into one column
SQL
20 votes376 views1 answer
Sql change column types
SQL
44 votes457 views4 answers
Mysql alter table add column first
SQL
0 vote364 views2 answers
Postgresql change user role grant
SQL
3 votes358 views1 answer
Mysql set field unique
SQL
1 vote384 views1 answer
Mysql curdate between two dates
SQL
1 vote344 views2 answers
Find a column in all tables mysql
SQL
0 vote370 views1 answer
Sql cmd no truncate
SQL