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 vote261 views1 answer
Manage Database in MySQL
SQL
0 vote153 views1 answer
Java spring boot connect to sql server
SQL
1 vote205 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote205 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote194 views1 answer
Mysql group by derived column
SQL
0 vote258 views1 answer
Mariadb used space
SQL
0 vote218 views1 answer
Sql value exists in column
SQL
3 votes183 views2 answers
Oracle grants
SQL
0 vote219 views1 answer
Oracle decode
SQL
4 votes181 views1 answer
Mysql insert from local csv
SQL