if it is before insert or update trigger, trigger wil fire first, if it i

which will fire first ? Trigger or Constraint

Question Posted / rajesh

Answer Posted / rajesh

if it is before insert or update trigger, trigger wil fire
first, if it is after insert or upadate constraints will
execute first.

Is This Answer Correct ?

26 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is nosql vs sql?

1118

how can we destroy the session, how can we unset the variable of a session? : Sql dba

932

Which command is used to call a stored procedure?

949

how do you tune the slow running queries in oracle db , explain the methodology

2028

Explain normalization and what are the advantages of it?

890

What are the disadvantages of file system?

1158

Name some usages of database trigger?

961

What is a unique key and primary key and foreign key?

914

What is trigger in pl sql?

953

What are inner and outer joins examples of both?

877

Explain ddl statements in pl/sql?

956

What is pl sql package?

990

What do you mean by “trigger” in sql?

1015

Can we create view in stored procedure?

908

What is a sql profiler?

957