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

2 votes262 views4 answers
List databases in sql server
SQL
9 votes220 views2 answers
Sql server check table exists
SQL
0 vote206 views1 answer
Postgres statistics
SQL
0 vote199 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote229 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote192 views1 answer
Commit transaction sql
SQL
0 vote232 views1 answer
How to check database engine in mysql
SQL
0 vote192 views1 answer
Sql server manager close connection
SQL
1 vote190 views1 answer
Xampp import sql file command line
SQL
5 votes189 views3 answers
How to remove unique key constraint in mysql
SQL