create table new_dept (depart_id number, department_name varchar2(30), location_id number ,fname varchar2(30) ,sal number);

create table new_cms  ( fname varchar2(30), lname varchar2(30) , empno number, sal number);

create view cmsview AS
SELECT d.depart_id, d.department_name,d.location_id,c.fname,c.sal from new_dept d,new_cms c;


CREATE OR REPLACE TRIGGER new_cms_dept
INSTEAD OF INSERT OR UPDATE OR DELETE ON cmsview
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO new_cms
VALUES (:NEW.fname, :NEW.lname, :NEW.empno, :NEW.sal);
UPDATE new_dept
SET sal = sal+ :NEW.sal
WHERE depart_id = :NEW. depart_id;
ELSEF DELETING THEN
DELETE FROM new_cms
WHERE empno = :OLD.empno;
END IF;
END;

:NEW. depart_id;

:NEW.depart_id;

ELSEF DELETING THEN

ELSIF DELETING THEN

select e  . sal from scott .emp e;

PLS-00049: bad bind variable 'NEW.'