Insert all in sql

INSERT ALL  
  INTO table_name (column1, column2, column_n) VALUES (expr1, expr2, expr_n)  
  INTO table_name(column1, column2, column_n) VALUES (expr1, expr2, expr_n)  
  INTO table_name (column1, column2, column_n) VALUES (expr1, expr2, expr_n)  
SELECT * FROM dual;

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

Similar codes

0 vote205 views1 answer
Sql find gaps in date ranges
SQL
0 vote270 views5 answers
Right join
SQL
1 vote219 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
1 vote216 views1 answer
Mysql dump specific tables
SQL
0 vote250 views1 answer
Display all node label neo4j
SQL
0 vote216 views1 answer
Hibernate show sql xml property
SQL
0 vote271 views3 answers
Mysql keyword search
SQL
0 vote207 views1 answer
Mysql add root password
SQL
0 vote211 views1 answer
Sql injection mitigation
SQL
5 votes201 views1 answer
How to get all dates in a month in oracle
SQL