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 vote204 views1 answer
Influxdb clone measurement
SQL
4 votes198 views1 answer
Sql delete where in select
SQL
4 votes212 views1 answer
Create column mysql terminal
SQL
1 vote259 views1 answer
Sql server locks
SQL
2 votes239 views1 answer
Sql get the name of user pc
SQL
0 vote229 views1 answer
Oracle chain step succeeded
SQL
0 vote167 views0 answer
SQL
0 vote260 views1 answer
Drop view sql
SQL
0 vote213 views1 answer
New rails app with mysql
SQL
0 vote225 views1 answer
To Create directory
SQL