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 vote117 views1 answer
Oracle compile schema
SQL
-1 vote109 views1 answer
Utf8_encode mysql
SQL
14 votes96 views3 answers
Trim sql
SQL
0 vote64 views1 answer
Update set with join pl sql
SQL
16 votes98 views1 answer
Mysql mediumint max value
SQL
0 vote114 views2 answers
How to type a blank discord messgae
SQL
0 vote233 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote101 views1 answer
Sql how to duplicate a table
SQL
0 vote100 views1 answer
Mysql select all table that have field names
SQL
0 vote119 views1 answer
Query archive mode
SQL