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 vote205 views1 answer
Netstat -tln mysql
SQL
2 votes215 views1 answer
Oracle sql merge
SQL
0 vote217 views1 answer
Oracle grant create job
SQL
0 vote233 views1 answer
Implode in sql query
SQL
17 votes327 views4 answers
Show all tables in oracle
SQL
5 votes223 views4 answers
Traduction
SQL
1 vote199 views1 answer
Mysql select row max date
SQL
1 vote210 views1 answer
How to see all table partition in oracle
SQL
3 votes193 views2 answers
Oracle sql drop sequence
SQL
0 vote199 views1 answer
T sql cursor tr
SQL