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 vote308 views1 answer
Sql find all different values in column
SQL
1 vote294 views1 answer
Mysql show table character set
SQL
0 vote308 views1 answer
Min mysql
SQL
0 vote340 views1 answer
Get role postgres
SQL
0 vote301 views2 answers
Csv into data postgres
SQL
0 vote297 views1 answer
Mysql change timestamp on update
SQL
0 vote306 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote349 views1 answer
Pl sql join 3 tables
SQL
0 vote313 views1 answer
Transaction database with php
SQL
2 votes304 views2 answers
Sql strip non alphanumeric characters
SQL