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 vote148 views1 answer
Sum value by month sql
SQL
0 vote118 views1 answer
Sql runnignsum
SQL
2 votes142 views1 answer
Sql create database
SQL
0 vote152 views1 answer
Mysql select inside sum
SQL
0 vote139 views1 answer
Mql5 list all available symbols
SQL
8 votes156 views3 answers
SQL column name
SQL
0 vote146 views1 answer
Low level operator in dbms
SQL
0 vote141 views1 answer
How to check if there is no database schema
SQL
0 vote162 views1 answer
Sql #region
SQL
3 votes166 views1 answer
Unsigned int in mysql
SQL