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

5 votes241 views1 answer
How to get all dates in a month in oracle
SQL
1 vote218 views1 answer
Select 2 rows in sql
SQL
3 votes240 views2 answers
Mysql select database
SQL
5 votes239 views5 answers
Find max number in sql
SQL
0 vote229 views1 answer
Connexion mysql
SQL
16 votes231 views2 answers
Add column if not exists mysql
SQL
1 vote239 views1 answer
Oracle select row max date
SQL
3 votes225 views2 answers
Oracle grants
SQL
4 votes240 views4 answers
Pl sql output
SQL
0 vote253 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL