Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18272 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 an index in sql with example?
What is difference between rank () row_number () and dense_rank () in sql?
How can I see all tables in sql?
How are sql commands classified?
what is the difference between $message and $$message? : Sql dba
Why function is used in sql?
How do I restart sql?
What is PL/SQL Records?
what is the difference between truncate and drop statements? : Sql dba
Is inner join faster than left join?
What is procedure in pl sql?
What are joins in sql?
Where is all the data on the internet stored?
How do I trace sql profiler?
Define tables and fields in a database
