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 vote281 views1 answer
Isnull in sqlite
SQL
0 vote263 views1 answer
Date diff sql
SQL
0 vote277 views1 answer
Sqlcmd no headers
SQL
20 votes283 views6 answers
Creating a table in sql
SQL
0 vote290 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote271 views1 answer
Timestamp in sqlite
SQL
5 votes286 views1 answer
Dbms_metadata.get_ddl table
SQL
6 votes291 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes305 views2 answers
Create temporary table in mysql
SQL
0 vote246 views1 answer
Create dabase postgresql
SQL