which will fire first ? Trigger or Constraint

Question Posted / parag tyagi

24 Answers
51218 Views
i2, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which will fire first ? Trigger or Constraint..

Answer / pradeep

TRigger fires fist, it dose not matter is it befor or
after, please see the below trigger. Even i am not entering
not a valid DEPTNO, still trigger fires first and then
constraint error comes

CREATE OR REPLACE TRIGGER EMPTRIGGER after INSERT ON EMP
FOR EACH ROW
BEGIN
--- RAISE_APPLICATION_ERROR(-20201,'INVALID NUMBER');
dbms_output.put_line(
'in triggeerssssssssssssssssssssssssssssssssssssssssss');
END;
SQL> /

Trigger created.

SQL> INSERT INTO EMP(EMPNO,DEPTNO) VALUES(3333,50);
in triggeerssssssssssssssssssssssssssssssssssssssssss
INSERT INTO EMP(EMPNO,DEPTNO) VALUES(3333,50)
*
ERROR at line 1:
ORA-02291: integrity constraint (SCOTT.FK_DEPTNO) violated -
parent key not
found

Is This Answer Correct ?

0 Yes

2 No

which will fire first ? Trigger or Constraint..

Answer / dhananjay kumar singh

I am know trigger is fire firstly because trigger are
automatically fired and constraint are not fired
automatically.

Is This Answer Correct ?

0 Yes

2 No

which will fire first ? Trigger or Constraint..

Answer / dhanashree

Trigger will fire first because the trigger fires at the
table level and the constraint fires at column level

Is This Answer Correct ?

3 Yes

7 No

which will fire first ? Trigger or Constraint..

Answer / roopa

trigger fires first.

Is This Answer Correct ?

1 Yes

29 No

Post New Answer