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 vote343 views1 answer
Sql server get date of previous sunday
SQL
2 votes323 views1 answer
Apex date today add days
SQL
1 vote388 views1 answer
Hangfire clear all jobs
SQL
0 vote329 views1 answer
C# datetime to sql server datetime
SQL
1 vote372 views1 answer
T-sql find object by name
SQL
0 vote293 views1 answer
Sql new line output
SQL
0 vote368 views1 answer
Psql store procedure-return multiple table values
SQL
1 vote349 views1 answer
Alphabetical order mysql
SQL
0 vote340 views1 answer
Set a value by excuting stored procedure
SQL
3 votes320 views1 answer
How to check schema privileges in oracle
SQL