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 votes186 views1 answer
Mysql time ago difference
SQL
5 votes166 views2 answers
Sql conn
SQL
0 vote203 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
9 votes172 views2 answers
Nosql databases
SQL
0 vote263 views1 answer
Mysql readable output
SQL
1 vote167 views1 answer
Media sql
SQL
2 votes192 views1 answer
Express api ith mysql data
SQL
0 vote142 views1 answer
Copy data from cell to cell mysql
SQL
-2 votes188 views1 answer
How to open database
SQL
1 vote178 views1 answer
Sql pick random row
SQL