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

6 votes150 views2 answers
Oracle
SQL
-1 vote163 views1 answer
What is in operator
SQL
0 vote164 views3 answers
Delete in SQL SERVER
SQL
3 votes167 views1 answer
V$session not found in oracle
SQL
0 vote187 views1 answer
Postgres list users and roles
SQL
0 vote156 views1 answer
Postgres where
SQL
0 vote162 views2 answers
Generate sql trigger through ef migration
SQL
19 votes166 views3 answers
Grant mysql
SQL
3 votes157 views4 answers
Mysql decimal
SQL
0 vote142 views1 answer
Mysql error 1452
SQL