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

3 votes333 views1 answer
How to remove characters from string in mysql
SQL
0 vote331 views1 answer
How to remove default in mysql
SQL
2 votes380 views1 answer
Oracle trace file
SQL
8 votes391 views1 answer
Oracle current date plus 1 month
SQL
0 vote377 views1 answer
Vbscript connect mssql
SQL
2 votes355 views1 answer
Grant revoke privileges to mysql username
SQL
2 votes395 views3 answers
Mysql kill
SQL
6 votes356 views2 answers
Database url postgres
SQL
0 vote342 views1 answer
Postgres 11 add primary key
SQL
1 vote357 views2 answers
Mssql show database size
SQL