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 vote337 views1 answer
Install mysql on bash
SQL
0 vote308 views1 answer
Postgresql port 5432 not open
SQL
0 vote290 views1 answer
Mysql bind-address default value
SQL
2 votes287 views1 answer
Oracle apex who is connected
SQL
0 vote270 views1 answer
Minecraft duping allowed servers
SQL
-1 vote276 views1 answer
MYSQL stored procedure select from
SQL
0 vote264 views2 answers
Avg() sql
SQL
2 votes296 views4 answers
2nd highest salary in mysql
SQL
0 vote284 views1 answer
Get the previous column of a table in mysql
SQL
0 vote324 views1 answer
"Hello User Name"
SQL