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

2 votes252 views2 answers
Mysql limit
SQL
9 votes266 views1 answer
Alter table column change data type to text mysql
SQL
0 vote287 views2 answers
Coursera spark sql max count
SQL
0 vote250 views2 answers
Create sequence if not exists postgres
SQL
6 votes268 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
0 vote257 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote207 views1 answer
Update sql join multiple tables
SQL
1 vote259 views1 answer
Get parameter value in mysql trigger
SQL
0 vote263 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
4 votes248 views3 answers
Mysql varchar length
SQL