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 vote194 views1 answer
List column names of multiple tables psql
SQL
0 vote209 views1 answer
Selects all the columns from the sailors table
SQL
0 vote227 views1 answer
Play framework connection via windows sql server
SQL
0 vote277 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote208 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote250 views1 answer
Float precision in psql
SQL
0 vote205 views1 answer
Sql server list table sizes
SQL
0 vote201 views1 answer
Soql update query
SQL
4 votes197 views2 answers
Sql server date now
SQL
1 vote198 views1 answer
Mysql select month and year
SQL