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 vote222 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
-1 vote200 views5 answers
Online sql to linq generator
SQL
0 vote207 views2 answers
Postgres show current role
SQL
17 votes208 views5 answers
Order by sql
SQL
0 vote186 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote193 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
3 votes224 views2 answers
Mysql update row
SQL
2 votes213 views2 answers
Postgres select duplicate columns
SQL
0 vote207 views1 answer
Soql user profile
SQL
13 votes340 views4 answers
Sql joining 3 tables
SQL