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 vote360 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote318 views1 answer
Postgres division by zero
SQL
1 vote395 views1 answer
Oracle insert multiple rows into same table
SQL
1 vote350 views1 answer
Oracle lock user
SQL
0 vote387 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote387 views1 answer
Count columns psql(PostreSQL)
SQL
25 votes417 views1 answer
How to update an attribute in MySQL
SQL
0 vote418 views1 answer
Drop a view in sqlite
SQL
0 vote342 views1 answer
Count the table indatabase
SQL
4 votes364 views2 answers
Convert utc to est sql
SQL