Interested to Buy Any Domain ? << Click Here >> for more details...
which will fire first ? Trigger or Constraint
- 24 Answers
- 51401 Views
- i2, IBM, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
This is for the people who says 'No' to the answer no 7.
As i still believe that it totally depends upon the timings of the trigger.
Consider the below example:
Example1: If i created a trigger as Before insert/update/delete on a table. Whenever user will perform any DML operation on the said table, the trigger will always executes first then it will check the constraint.
Example2: If I created a trigger as After Insert/Update/Delete on a table. Whenever user will perform a DML operation on the said table, the constraint will execute first then the trigger will be executed.
Please mail me if I am wrong on the below mail id:
raviindian2114@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is online transaction processing (oltp)?
How do you update a table in sql?
What are the different types of dbms?
Why we use pl sql?
What does t sql mean?
What is the difference between Union and Union all. Which is faster.
How do I clear the screen in sql plus?
What is vector point function?
Which data dictionary views have the information on the triggers that are available in the database?
How many types of cursors supported in pl/sql?
What is denormalization in a database?
How many types of indexes are there in sql?
What is dml with example?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Why do we need pl sql?
