Inserting an EMPLOYEES Record: Update a Sequence
We need a fixed EMPLOYEE_ID, number 300 for a record in the EMPLOYEES table in order for our example code to work. When the sample EMPLOYEES table is initially installed, there are about 100 records, with EMPLOYEE_IDs from 100 to about 200. Generally, inserts into the EMPLOYEES table use the next value of the sequence, EMPLOYEES_SEQ like this (do not execute this yet—this is for reference only):
INSERT INTO employees
(employee_id, first_name, last_name, email, phone_number, hire_date,
job_id, salary, commission_pct, manager_id, department_id)
VALUES
(employees_seq.NEXTVAL, 'David', 'Coffin', 'DAVID.COFFIN', '800.555.1212', SYSDATE, 'SA_REP', 5000, 0.20, ...Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
