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 vote184 views1 answer
How to execute stored output to csv files
SQL
1 vote154 views1 answer
Postgresql last element of array
SQL
0 vote161 views1 answer
Procedures and functions in pl/sql
SQL
0 vote216 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote199 views4 answers
How to drop all tables in sql
SQL
1 vote201 views2 answers
Pl sql case
SQL
0 vote180 views1 answer
Lister les index d'une table oracle
SQL
11 votes204 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote199 views2 answers
Temp tables in sql server
SQL
0 vote207 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL