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 vote261 views1 answer
<sql:datasource var="Snapsho"
SQL
-1 vote185 views2 answers
Mysql get day of week
SQL
0 vote185 views1 answer
Postgresql auto increment not working
SQL
39 votes293 views5 answers
Sql drop column
SQL
0 vote215 views1 answer
Openquery update linked server
SQL
3 votes233 views1 answer
Oracle function
SQL
0 vote188 views1 answer
Drop unique
SQL
6 votes224 views2 answers
Oracle compile trigger
SQL
2 votes195 views1 answer
SQL IF ELSE
SQL
0 vote196 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL