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

3 votes340 views1 answer
Kill mysql processlist in whose time more than 200
SQL
2 votes334 views1 answer
Query any digits record
SQL
0 vote362 views10 answers
Sql statement checker corrector
SQL
0 vote331 views5 answers
Select concat alter table mysql
SQL
12 votes396 views6 answers
Change mysql root password
SQL
9 votes324 views2 answers
Sql limit order by
SQL
0 vote338 views1 answer
Creation d'un trigger sql
SQL
1 vote339 views2 answers
Begin transaction in sql
SQL
3 votes375 views2 answers
Synonym oracle
SQL
-1 vote304 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL