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

2 votes132 views1 answer
Sql server case sensitive search
SQL
0 vote135 views1 answer
How to check the port of mysql installation in mac
SQL
5 votes128 views1 answer
Postgres integer to serial
SQL
0 vote148 views1 answer
For row in sql database python loop
SQL
1 vote135 views1 answer
List index mysql cli
SQL
0 vote133 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote128 views1 answer
Check if record exists mysql
SQL
6 votes127 views1 answer
Oracle list primary key
SQL
2 votes121 views1 answer
Oracle sql drop column if exists
SQL
0 vote139 views2 answers
Python mysql create table if not exists
SQL