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

3 votes447 views2 answers
Oracle drop sequence
SQL
5 votes362 views1 answer
How to get all dates in a month in oracle
SQL
1 vote459 views1 answer
Difference between where and having clause
SQL
0 vote366 views2 answers
What is the default password for sql server sa
SQL
1 vote354 views2 answers
Rebuild index sql server
SQL
0 vote385 views1 answer
Primary key start from number
SQL
0 vote359 views1 answer
Mysql undo delete
SQL
0 vote351 views1 answer
Postgres reorder columns
SQL
0 vote368 views1 answer
Select a row include list of array with join table SQL
SQL
3 votes354 views1 answer
Oracle show trigger code
SQL