What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 17234 Views
- I also Faced
- E-Mail Answers
Answer Posted / santu sarkar
1> A database trigger is written in PL/SQL. Integrity Constraints are CHECK Constraints, Not NULL, Unique key, primary key and foreign key.
2> Trigger will not affect the existing data. Constraint will affect the existing data.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is difference between db2 and sql?
What is not null in sql?
State few characteristics of pl/sql?
how to enter numeric values as hex numbers? : Sql dba
What is materialized view. What are different methods of refresh?
What is the difference between the conventional and direct path loads? : aql loader
What is a sql schema used for?
What is count * in sql?
What is assignment operator in pl sql?
How exception is different from error?
Is sqlexception checked or unchecked?
what is sql in mysql? : Sql dba
What is pl sql quora?
How to pipe multiline string to isql?
what is a composite key ? : Sql dba
