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 votes142 views1 answer
Sql server version query
SQL
0 vote142 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote178 views1 answer
Create table as select sql server error
SQL
0 vote142 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
10 votes167 views4 answers
Inner join in update query mysql
SQL
0 vote135 views1 answer
Psql list rules
SQL
0 vote144 views1 answer
Min salary in sql
SQL
0 vote171 views1 answer
Query to insert image
SQL
4 votes139 views2 answers
Mysql select where starts with
SQL
0 vote145 views1 answer
Mysql locate
SQL