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 vote134 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote123 views1 answer
Postgres first_value in gropby
SQL
0 vote179 views1 answer
SQL query to verify the size of the table
SQL
0 vote147 views1 answer
Pgadmin save data greyed out
SQL
0 vote131 views1 answer
Sqlite commands
SQL
0 vote134 views1 answer
Oracle running queries sql
SQL
1 vote129 views1 answer
Oracle create as select
SQL
3 votes129 views3 answers
Docker create postgresql database
SQL
1 vote142 views2 answers
Mysql error 1215
SQL
0 vote116 views1 answer
Sql get date from timestamp
SQL