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

7 votes186 views4 answers
Index in mysql
SQL
1 vote124 views1 answer
Insert into sql
SQL
2 votes182 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
3 votes182 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote201 views1 answer
Primary key start from number
SQL
0 vote181 views2 answers
Pop sql insert value into
SQL
0 vote261 views1 answer
Last date for each user sql
SQL
1 vote180 views1 answer
Mariadb get column names from table
SQL
2 votes171 views1 answer
Sql update alias
SQL
0 vote200 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL