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 votes219 views2 answers
Mysql on duplicate key ignore
SQL
103 votes356 views1 answer
Like sql
SQL
0 vote215 views1 answer
Sql beginning of previous month
SQL
0 vote215 views1 answer
Create or replace view postgress
SQL
0 vote222 views2 answers
Imageview setimageresource null
SQL
0 vote215 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
-1 vote225 views1 answer
Get id from just inserted row mysql server python
SQL
14 votes221 views2 answers
Oracle export trigger ddl
SQL
0 vote222 views1 answer
Postgres create extension if not exists
SQL
1 vote227 views1 answer
Describe table in sql
SQL