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 vote79 views1 answer
Copy table dbeaver
SQL
0 vote156 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote142 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote139 views1 answer
Char vs varchar2 in sql
SQL
1 vote144 views1 answer
Count mysql server db tables
SQL
0 vote132 views1 answer
Restore backupfile discourse
SQL
0 vote136 views1 answer
Access mysql database docker container shell
SQL
37 votes140 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote153 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote149 views1 answer
How to install Firebird
SQL