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 vote117 views1 answer
Docker export psql sql
SQL
0 vote128 views1 answer
Create table database in psql
SQL
0 vote117 views1 answer
Oracle simple quote
SQL
0 vote118 views1 answer
Uuid sqlalcomany
SQL
1 vote119 views1 answer
Mysql check string don't have number
SQL
4 votes128 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
2 votes142 views1 answer
Mysql select true or false
SQL
1 vote130 views3 answers
Remove unique key from a table
SQL
1 vote150 views1 answer
Insert column after column mysql
SQL
0 vote139 views1 answer
Sql getdate minus 1 day without time
SQL