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 vote118 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote156 views1 answer
Sql date with year
SQL
0 vote141 views1 answer
How to check which table has data in mysql
SQL
2 votes134 views2 answers
Sql percentage
SQL
0 vote121 views2 answers
Sql count number of rows after group by
SQL
0 vote112 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote119 views1 answer
Case insensitive sql
SQL
5 votes119 views1 answer
Sql first day of current year
SQL
0 vote125 views1 answer
Mysql undo delete
SQL
0 vote131 views1 answer
Convert uniqueidentifier to varchar in sql
SQL