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

14 votes167 views3 answers
Alter foreign key
SQL
0 vote177 views1 answer
Oracle sql number to varchar2
SQL
1 vote172 views1 answer
Sql exclude duplicates and find even id
SQL
4 votes308 views2 answers
Sql display today's date
SQL
5 votes125 views1 answer
Mongodb vs
SQL
2 votes155 views1 answer
Oracle cpu per session
SQL
0 vote189 views1 answer
Sql create and grant user access to database
SQL
49 votes251 views6 answers
Get duplicate records in sql
SQL
0 vote166 views1 answer
Get last three characters in mysql column
SQL
6 votes213 views1 answer
Postgresql get year
SQL