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 votes188 views1 answer
Get all elements sql
SQL
2 votes188 views4 answers
Mysql get all tables row count
SQL
9 votes233 views1 answer
No sql
SQL
0 vote174 views1 answer
Sql gather statistics to increase performance
SQL
16 votes186 views4 answers
Ascending order mysql
SQL
0 vote242 views1 answer
Mariadb disable foreign key checks
SQL
0 vote198 views1 answer
MySql Modify Increment
SQL
2 votes253 views1 answer
Oracle block
SQL
3 votes216 views2 answers
Synonym oracle
SQL
1 vote244 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL