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

24 votes139 views6 answers
Sql change table name
SQL
1 vote131 views1 answer
How to find median of a column sql
SQL
0 vote197 views1 answer
Mysql get nested records
SQL
6 votes161 views2 answers
WHERE value IS sql
SQL
0 vote137 views1 answer
Insert array into mysql column
SQL
23 votes142 views2 answers
Query to delete a database in mysql
SQL
0 vote144 views2 answers
Generate sql trigger through ef migration
SQL
3 votes175 views2 answers
@sqlresultsetmapping
SQL
6 votes150 views2 answers
Difference between join vs union
SQL
6 votes218 views1 answer
Sql insert values into table
SQL