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 vote206 views1 answer
How to open mysql in docker
SQL
0 vote202 views1 answer
Oracle sql generate list of days
SQL
0 vote203 views1 answer
T sql check active deadlock
SQL
5 votes210 views2 answers
Get columns number sql
SQL
0 vote191 views1 answer
How to increase the width of the screen in oracle
SQL
7 votes209 views2 answers
Oracle sql drop index
SQL
0 vote216 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
12 votes235 views6 answers
Distinct in sql server
SQL
1 vote208 views1 answer
Full sql mode
SQL
5 votes230 views3 answers
Show indexes mysql
SQL