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

2 votes114 views1 answer
Oracle current date without time
SQL
0 vote146 views1 answer
Power query case when
SQL
6 votes165 views1 answer
T-sql test if table exists
SQL
0 vote144 views1 answer
Mssql current date
SQL
1 vote199 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote181 views1 answer
"Hello User Name"
SQL
5 votes160 views2 answers
Oracle find all tables with column name
SQL
9 votes169 views4 answers
Last mysql
SQL
9 votes164 views4 answers
Mysql set id auto increment
SQL
1 vote179 views2 answers
One to one and one to many relationship
SQL