What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 6638 Views
- Synergy, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are indexes in oracle?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
Explain phantom deadlock?
What is a trace file?
What does currency type mean in database?
What is the candidate key used for?
what is the role of auditor in auditing data oriented applications?
How to do performance tunning a database in DB2 V8.2 UDB in linux
Explain artificial key?
What is odm in database?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
Is hive a database?
Can you create a database in word?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
