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 vote147 views1 answer
Stored procedure function relation
SQL
0 vote134 views1 answer
Concat column value of same user in mysql
SQL
0 vote144 views1 answer
Set column in all row mysql
SQL
0 vote153 views1 answer
Group by join columns per table
SQL
0 vote142 views1 answer
Mysqldump ignore table
SQL
3 votes144 views4 answers
Show sql server database
SQL
0 vote185 views1 answer
Sql to excel pgadmin
SQL
1 vote145 views3 answers
How to get date in sql
SQL
0 vote193 views1 answer
Cahnge column name apex oracle
SQL
4 votes137 views2 answers
Tsql utf to local time
SQL