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

2 votes327 views1 answer
How to create sql database
SQL
0 vote192 views1 answer
Mysql root permission denied lost
SQL
1 vote305 views1 answer
Mysql monthname
SQL
0 vote174 views2 answers
Clear window pl sql
SQL
6 votes227 views6 answers
Rename column postgres
SQL
0 vote180 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote206 views2 answers
Sql server select first day of previous year
SQL
0 vote229 views1 answer
How to subquey to do not load in live database in
SQL
0 vote184 views1 answer
Postgres create extension if not exists
SQL
0 vote185 views1 answer
What is between keyword used for
SQL