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

0 vote259 views1 answer
SQL joins in python
SQL
0 vote263 views1 answer
Check constraint is violated
SQL
3 votes278 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote235 views1 answer
How to install mysql without admin rights
SQL
0 vote223 views1 answer
Import mysql'
SQL
25 votes238 views6 answers
Sql update query
SQL
3 votes228 views2 answers
WhereIn SQL
SQL
0 vote237 views1 answer
Oracle list of long running queries
SQL
1 vote240 views1 answer
Pgsql sum switch case
SQL
0 vote225 views1 answer
Generate random & unique mysql string
SQL