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 votes165 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote156 views1 answer
Less than and between in sql query
SQL
0 vote153 views1 answer
Mysql sleep connections
SQL
1 vote176 views1 answer
Mysql current running queries
SQL
0 vote148 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote147 views1 answer
Postgresql where clause not working
SQL
-1 vote213 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote145 views1 answer
Make a socket server to detect changes in mysql
SQL
2 votes156 views2 answers
Mysql limit
SQL
1 vote162 views2 answers
Rebuild index sql server
SQL