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 vote155 views2 answers
How to get the date from datetime in mysql
SQL
1 vote103 views1 answer
Convert money to varchar sql server
SQL
1 vote186 views1 answer
Sql oracle update multiple rows
SQL
0 vote142 views1 answer
Mysql Digital Ocean connection problems
SQL
2 votes146 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
14 votes138 views4 answers
Sql compiler
SQL
1 vote108 views2 answers
Delete auto increment mysql
SQL
0 vote276 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote138 views1 answer
Write sql query to show the details start from digit
SQL
0 vote140 views1 answer
How to check xampp mysql password
SQL