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

5 votes190 views1 answer
Oracle asynchronous procedure
SQL
1 vote122 views1 answer
Postgresql transaction discard all
SQL
1 vote113 views1 answer
Find logged in users mysql
SQL
1 vote121 views1 answer
Partition by sql server
SQL
0 vote124 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote118 views1 answer
Mysql select where field like in list
SQL
11 votes236 views2 answers
Import mysql dump command line windows
SQL
14 votes118 views3 answers
SQL trim
SQL
0 vote109 views1 answer
Get who is hired in january in sql
SQL
1 vote116 views2 answers
Regex starts with
SQL