Insert Sample Data

Next, insert some sample employee records:

INSERT INTO employees (first_name, last_name, hire_date, salary, department_id) VALUES ('John', 'Doe', TO_DATE('2020-01-15', 'YYYY-MM-DD'), 60000, 1);
INSERT INTO employees (first_name, last_name, hire_date, salary, department_id) VALUES ('Jane', 'Smith', TO_DATE('2019-03-22', 'YYYY-MM-DD'), 75000, 2);
INSERT INTO employees (first_name, last_name, hire_date, salary, department_id) VALUES ('Alice', 'Johnson', TO_DATE('2021-07-30', 'YYYY-MM-DD'), 55000, 1);
INSERT INTO employees (first_name, last_name, hire_date, salary, department_id) VALUES ('Bob', 'Brown', TO_DATE('2018-06-15', 'YYYY-MM-DD'), 80000, 3);