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 vote326 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote314 views1 answer
Renommer table sql
SQL
0 vote320 views1 answer
Plpgsql if statement
SQL
0 vote354 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote331 views1 answer
Dasebase_url-postgres for windows
SQL
-1 vote364 views1 answer
Mysql faster insert
SQL
0 vote320 views1 answer
Sql remove last x char
SQL
28 votes385 views6 answers
Sql update
SQL
0 vote360 views1 answer
Sql delete caracter list
SQL
0 vote331 views1 answer
Data structures in sql
SQL