Oracle multiple insert

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

Oracle multiple insert

INSERT INTO my_table (col1, col2)
SELECT 8000, 0 FROM DUAL
UNION ALL
SELECT 8001, 5 FROM DUAL;

Similar codes

19 votes182 views5 answers
Display table in sql
SQL
0 vote183 views1 answer
C# sql transaction multiple connections
SQL
6 votes171 views3 answers
Create database mysql utf8
SQL
2 votes171 views1 answer
Import large .sql files into lampp
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL
0 vote158 views2 answers
Postgres another version
SQL
34 votes168 views6 answers
Sql change data type
SQL
5 votes175 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote153 views1 answer
Oracle last connection
SQL
11 votes161 views1 answer
Creating tables in sql with python
SQL