What are the differences between Database Trigger and
Integrity constraints ?
Answers were Sorted based on User's Feedback
Answer / ganesh
Trigger: A set of pl/sql statments that are stored
permenantly in the database it activates when ever the DML
operations performed on the table.
constraints: Set of predefind rules are applied on table
column while creating the table or after creating the
table. and automatically performed when DML statemets are
performed by user.
the main differece between the two is
trigger will not effect the existing rows(it will effects
only new rows after creating a trigger on a table),
where as in the constraints it will effect the existing
rows also.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / nilkantha
I can't find the answer.Pls Give me the right answer
Is This Answer Correct ? | 1 Yes | 2 No |
Explain storage manager?
What is the purpose of TNS?
What is a Transformation?
give a simple example of physical and logical data independence
What is ole db source in ssis?
Explain file manager?
What is the advantage of varchar2 over char?
How does non-cluster index functions?
What is the difference between database and server?
hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)
What does new grouping sets enables you to do?
List some advantages of dbms.