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 vote188 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote152 views1 answer
This week mysql
SQL
5 votes131 views3 answers
Day of week postgresql
SQL
2 votes126 views1 answer
Sql column values comma separated
SQL
0 vote169 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote134 views3 answers
CONTACT FORM SQL
SQL
1 vote124 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote125 views1 answer
Java sql timestamp now
SQL
3 votes129 views2 answers
Tsql join multiple record in one string
SQL
0 vote171 views1 answer
Sql pivot table
SQL