Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18230 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 varchar used for?
How do you remove duplicates without using distinct in sql?
How do I order by ascending in sql?
Can I create table without primary key?
What does an inner join do?
What is the difference between left outer join and left join?
Is natural join and inner join same?
what are the difference between clustered and a non-clustered index? : Sql dba
What is a Mapplet?
What are the types of records?
How many types of triggers are there in pl sql?
What is primary key secondary key alternate key candidate key?
Why do we use view in sql?
What is %rowtype in pl sql?
What is difference between inner join and self join?
