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

3 votes193 views1 answer
What is having
SQL
2 votes200 views3 answers
Sql function
SQL
0 vote155 views1 answer
Materialized view redshift
SQL
12 votes176 views1 answer
Docker run mysql image
SQL
1 vote201 views1 answer
OSError: mysql_config not found
SQL
1 vote162 views1 answer
Mysql check if string contains comma separated
SQL
0 vote175 views1 answer
How to write if case in select query in select statement
SQL
3 votes159 views2 answers
Oracle sql select all days between two dates except weekends
SQL
1 vote168 views1 answer
How to change owner in postgres
SQL
0 vote167 views1 answer
Difference between varchar and varchar2
SQL