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 vote337 views1 answer
Oracle string substitution
SQL
10 votes363 views4 answers
SELECT FROM WHERE
SQL
0 vote361 views1 answer
Change database name psql 8
SQL
1 vote322 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
2 votes375 views2 answers
Mysql does sentence contain word
SQL
0 vote352 views1 answer
How to check event scheduler status mysql
SQL
0 vote344 views1 answer
Mysql root permission denied lost
SQL
3 votes345 views2 answers
Current year sql
SQL
26 votes331 views6 answers
Modify column name in sql
SQL
9 votes369 views4 answers
Mysql set id auto increment
SQL