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 vote273 views1 answer
Postgres extract number from string
SQL
0 vote242 views1 answer
Mysql join column order By and group By
SQL
10 votes220 views3 answers
Join multiple tables sql
SQL
0 vote227 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote212 views1 answer
Oracle create package specification
SQL
0 vote292 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
2 votes214 views2 answers
Get all tables using like
SQL
0 vote207 views2 answers
Avg() sql
SQL
0 vote236 views2 answers
Sql day from datetime
SQL
0 vote174 views1 answer
Import csv to mysql
SQL