which will fire first ? Trigger or Constraint
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is mutating table error?
What is pl/sql tables?
What is difference between group by and partition by?
Can we rename a column in the output of sql query?
How do I start sql profiler?
What is embedded sql with example?
How do you write a subquery?
Is primary key always clustered index?
What is varchar example?
how to delete an existing column in a table? : Sql dba
how do you count the duplicate records in a table
What is synonyms?