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 vote335 views1 answer
How to create a table based on another table in mysql
SQL
16 votes344 views3 answers
Update table from another table
SQL
0 vote357 views1 answer
Select distinct after join
SQL
0 vote338 views1 answer
Multiple like values for single column postgres
SQL
0 vote312 views1 answer
Call function sql oracle
SQL
17 votes319 views3 answers
How to change a collumn name in sql
SQL
5 votes323 views1 answer
Oracle generate list of dates in between a date range
SQL
1 vote321 views1 answer
Mysql query bulk insert
SQL
0 vote370 views2 answers
How to install psql in ubuntu
SQL
0 vote303 views1 answer
Sql roll up rows into columns
SQL