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 vote356 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote335 views1 answer
Sql menampilkan data tabel
SQL
1 vote322 views2 answers
Replace text in sql
SQL
2 votes282 views2 answers
Mysql get last character of string
SQL
60 votes539 views6 answers
Add column in sql
SQL
0 vote354 views1 answer
Providername system.data. mysql
SQL
0 vote296 views1 answer
Mysql earlier than date
SQL
0 vote348 views1 answer
In query in sql
SQL
0 vote330 views1 answer
Mysql select statement after index
SQL
0 vote329 views1 answer
Formatting code with SQL Developer
SQL