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

1 vote126 views1 answer
Strict in postgres SQL
SQL
7 votes169 views1 answer
Alter sequence set current value oracle
SQL
0 vote174 views1 answer
Sql comand for removing data from table
SQL
1 vote171 views1 answer
Where database run
SQL
6 votes184 views2 answers
Postgresql restore from dump
SQL
0 vote179 views1 answer
Sql server alter table column nullable
SQL
4 votes197 views2 answers
Float postgres
SQL
1 vote173 views1 answer
Table information in sql server
SQL
2 votes188 views2 answers
Install postgresql
SQL
7 votes190 views2 answers
Where keyword sql
SQL