Oracle multiple insert

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

Oracle multiple insert

INSERT INTO my_table (col1, col2)
SELECT 8000, 0 FROM DUAL
UNION ALL
SELECT 8001, 5 FROM DUAL;

Similar codes

2 votes319 views1 answer
Postgresql create table as select
SQL
5 votes288 views1 answer
Mysql change primary key
SQL
0 vote314 views2 answers
Starts and end with vowel sql
SQL
8 votes323 views1 answer
Oracle search stored procedures for text
SQL
1 vote304 views3 answers
Showing all columns in an sqlite table
SQL
2 votes302 views2 answers
Created at and updated at in mysql
SQL
0 vote268 views1 answer
Postgresql import data from csv
SQL
6 votes314 views2 answers
Difference between join vs union
SQL
0 vote303 views1 answer
Group by join columns per table
SQL
0 vote309 views1 answer
Sql query contains multiple ids
SQL