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 vote201 views2 answers
Advantages of stored procedures sql
SQL
12 votes192 views4 answers
Psql command not found
SQL
0 vote208 views1 answer
Select top values sql
SQL
5 votes186 views1 answer
Sql asynchronous stored procedure call
SQL
-1 vote184 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
-1 vote211 views1 answer
Sql show custom constraints
SQL
0 vote157 views0 answer
SQL
0 vote197 views1 answer
Flush user resource mysql
SQL
0 vote186 views3 answers
Get count of null in column sql
SQL
2 votes208 views1 answer
Merge firstname and lastname in sql oracle
SQL