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 vote247 views1 answer
Take sql dump in to file
SQL
0 vote316 views1 answer
Delete from IN subquery
SQL
0 vote253 views2 answers
Get all index postgres
SQL
0 vote274 views1 answer
Mysql isshow
SQL
2 votes308 views1 answer
Python sql
SQL
1 vote259 views1 answer
Mysql show table character set
SQL
0 vote285 views1 answer
Command to give readonly access to a postgres sql user
SQL
3 votes306 views2 answers
Oracle drop sequence
SQL
6 votes270 views2 answers
How to copy data in sql
SQL
0 vote288 views1 answer
Get statis values sql
SQL