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

1 vote225 views1 answer
Oracle duration between timestamps
SQL
0 vote234 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote226 views1 answer
EnvironmentError: mysql_config not found
SQL
29 votes221 views6 answers
Delete all rows from table mysql
SQL
3 votes210 views1 answer
Difference sql vs mysql
SQL
0 vote221 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote228 views1 answer
Mysql cast null to string
SQL
-1 vote223 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote442 views1 answer
Power bi connect to postgresql
SQL
6 votes251 views2 answers
Mysql timestamp to date
SQL