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 vote133 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
16 votes141 views6 answers
Install sqlite3 python
SQL
0 vote146 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote154 views1 answer
Mql5 datetime get hour
SQL
2 votes127 views1 answer
Postgresql left join distinct on
SQL
2 votes145 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
-3 votes135 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote143 views1 answer
Convert epoch to date in sql server
SQL
0 vote140 views1 answer
Copy value from one column to another postgres
SQL
0 vote137 views1 answer
Postgresql interview questions
SQL