Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18251 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 primary key? : Sql dba
What are views in sql?
How do I count duplicates in sql?
What is trigger with example?
What is the use of procedures?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How to call shell script from pl sql procedure?
What is sql in oracle?
Write the alter statement to enable all the triggers on the t.students table.
How to use boolean type in select statement?
tell me about various levels of constraint. : Sql dba
What is difference between stored procedures and application procedures?
Is id a reserved word in sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What are the different ddl commands in sql?
