PL/SQL Trigger 9 – Trigger Having Conditions Example

Create trigger which prevent insertion/updation of EMPNO in EMP_<employee_id> table (Triggered only if inserting empno is greater than 1000)

Answer

CREATE OR REPLACE TRIGGER bf1_empp
BEFORE INSERT ON EMPPP_a5518
FOR EACH ROW
WHEN (NEW.EMPNO > 1000)
declare
    tot number(5);
BEGIN
    
    :NEW.TSAL:=:NEW.BSAL + :NEW.ALLW;
    
END bf1_empp;
/

 

INSERT INTO EMPPP_a5518 (EMPNO, NAME, BSAL, ALLW) VALUES (1,'jijo',45,67);



 

You can leave a response, or trackback from your own site.

Leave a Reply