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

4 votes114 views2 answers
Dbms_scheduler stop job
SQL
0 vote116 views1 answer
Get null value in sql
SQL
1 vote122 views1 answer
Mysql copy table1 to table2
SQL
0 vote109 views1 answer
Partitioning in oracle-base
SQL
1 vote123 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote120 views1 answer
Create dabase postgresql
SQL
16 votes125 views3 answers
Update table from another table
SQL
0 vote117 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
1 vote116 views1 answer
Oracle create program if no exists
SQL
1 vote123 views1 answer
Oracle sql average
SQL