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

3 votes178 views1 answer
Increment integer in table sql
SQL
0 vote195 views1 answer
"Hello User Name"
SQL
0 vote139 views1 answer
Postgresql add leading zeros
SQL
1 vote163 views1 answer
Mysql random limit 1
SQL
0 vote166 views1 answer
Mysql in clausule string array
SQL
0 vote162 views1 answer
Ms Sql set us timezone
SQL
1 vote146 views3 answers
Grant syntax in sql
SQL
0 vote219 views1 answer
Oracle temporary table
SQL
0 vote242 views2 answers
Return the number of records in a single table mysql
SQL
0 vote170 views1 answer
Mssql check if date is greater than today
SQL