Insert:
BEGIN
INSERT INTO employees
(employee_id, first_name, last_name, email, hire_date, job_id, salary)
VALUES(employees_seq.NEXTVAL, ‘Ruth’, ‘Cores’, ‘RCORES’,CURRENT_DATE, ‘AD_ASST’, 4000);
END; /
Update:
DECLARE
sal_increase employees.salary%TYPE := 800;
BEGIN UPDATE
SET
WHERE END;
/
Delete:
DECLARE
deptno employees.department_id%TYPE := 10;
BEGIN
DELETE FROM employees
WHERE department_id = deptno;
END; /
Merge:
BEGIN
MERGE INTO copy_emp c
USING employees e
ON (e.employee_id = c.empno)
WHEN MATCHED THEN
END; /