hello,
i have a problem in trigger. My trigger is

CREATE OR REPLACE TRIGGER duplicate_deptn o
BEFORE INSERT OR UPDATE OF deptno ON DEPT1
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
x NUMBER ;


BEGIN

SELECT COUNT(deptno)IN TO x FROM DEPT1 WHERE deptno=:NEW.dep tno;

IF INSERTING OR UPDATING THEN
IF x>0 THEN...