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

10 votes219 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote199 views2 answers
Postgresql variable in query
SQL
0 vote183 views1 answer
Sql date d'aujourd'hui
SQL
0 vote187 views1 answer
Update top 100 sql
SQL
0 vote190 views1 answer
Normalization in database 2nd normal form
SQL
0 vote205 views2 answers
Oracle create tablespace autoextend
SQL
0 vote194 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
2 votes191 views2 answers
Mamp connect mysql terminal
SQL
11 votes190 views1 answer
Get ddl materialized view oracle
SQL
1 vote253 views1 answer
Oracle apex version view
SQL