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 vote322 views1 answer
Vowels in sql
SQL
24 votes341 views6 answers
Replace mysql
SQL
0 vote321 views1 answer
Drush run sql select
SQL
8 votes316 views2 answers
Change name of colum in sql table
SQL
0 vote341 views1 answer
Best sql collation
SQL
0 vote311 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote343 views1 answer
Min:sec datediff mssql
SQL
1 vote303 views2 answers
Sql convert datetime to year month
SQL
0 vote319 views1 answer
WHERE not regex in SQL
SQL
0 vote312 views1 answer
Mysql change timestamp on update
SQL