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 vote329 views1 answer
Set statiscis on in sql server
SQL
0 vote349 views1 answer
Convert rows to columns in sql server
SQL
1 vote297 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
8 votes361 views1 answer
Racle create auto increment column
SQL
5 votes374 views1 answer
Oracle nls session
SQL
0 vote333 views1 answer
Comma seperated join mssql
SQL
13 votes356 views2 answers
Sql online compiler
SQL
1 vote391 views1 answer
Oracle create program if not exists
SQL
1 vote338 views1 answer
Show table status command in mysql
SQL
15 votes331 views2 answers
How to drop database name in postgresql
SQL