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

38 votes183 views6 answers
Ubuntu install mysql client
SQL
0 vote116 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote244 views1 answer
Sql datum formatieren
SQL
1 vote130 views3 answers
Postgresql crete view
SQL
0 vote110 views1 answer
Sqlite get date only
SQL
2 votes101 views2 answers
Set database timezone mysql
SQL
19 votes170 views5 answers
Mysql between date range
SQL
0 vote95 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote75 views1 answer
Postgres create database if not exists
SQL
1 vote92 views2 answers
T sql get foreign key
SQL