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 vote183 views2 answers
Check mysql timezone
SQL
1 vote192 views3 answers
Union SQL
SQL
5 votes212 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
10 votes197 views2 answers
Sql rtrim
SQL
0 vote187 views1 answer
Rabbitmq ui not working
SQL
-2 votes198 views1 answer
Remove root password mysql
SQL
3 votes193 views1 answer
Select count from table mysql
SQL
1 vote189 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote199 views1 answer
Delete record by id sql
SQL
6 votes201 views2 answers
Non relational database
SQL