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

1 vote208 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote236 views2 answers
Find lowest number in sql
SQL
0 vote178 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
18 votes190 views6 answers
Mysql create table
SQL
0 vote186 views2 answers
How to know the character set of an oracle databes
SQL
1 vote178 views1 answer
Sql upsert
SQL
0 vote176 views2 answers
Raise notice in postgresql function
SQL
1 vote177 views1 answer
How to use a trigger to validate input data
SQL
0 vote197 views1 answer
Mysql not defined
SQL
0 vote181 views1 answer
Longtext sql
SQL