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 vote272 views1 answer
Decalre temp table sql
SQL
1 vote271 views2 answers
Mysql select tables with name like
SQL
0 vote279 views1 answer
Mysql multiple group by
SQL
1 vote266 views3 answers
Postgresql crete view
SQL
3 votes280 views2 answers
Mysql config user password
SQL
0 vote269 views1 answer
Java spring boot connect to sql server
SQL
3 votes271 views1 answer
Select without null values sql
SQL
1 vote263 views1 answer
Mysql pretty date format
SQL
1 vote270 views1 answer
Mariadb alter user host
SQL
3 votes297 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL