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

0 vote355 views1 answer
Date on SQL
SQL
0 vote344 views1 answer
Select count postgres double row count > 1
SQL
5 votes348 views2 answers
Get columns number sql
SQL
0 vote391 views1 answer
How to use sqlcommand
SQL
2 votes353 views1 answer
Sql to char function with date
SQL
1 vote362 views1 answer
Mysql strict_trans_tables
SQL
0 vote532 views1 answer
Sql change a colum to unique
SQL
1 vote370 views1 answer
Drop primary key oracle
SQL
0 vote407 views1 answer
Eliminate zero from integer mysql
SQL
0 vote354 views1 answer
St_buffer mysql
SQL