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

9 votes277 views4 answers
How to create new user and database postgresql in ubuntu
SQL
13 votes263 views3 answers
Sql online code
SQL
1 vote267 views1 answer
Sql server find tables referenced foreign key
SQL
5 votes264 views2 answers
Ranking functions in sql
SQL
1 vote292 views1 answer
Search for replace in mysql
SQL
1 vote317 views1 answer
Last 24 HOUR data in mysql
SQL
21 votes309 views6 answers
Update sql
SQL
0 vote271 views1 answer
Oracle job class
SQL
12 votes284 views1 answer
Script to add new column in table sql
SQL
1 vote288 views2 answers
Mysql trim spaces
SQL