What are the differences between Database Trigger and
Integrity constraints ?

Answer Posted / rao

main diff is when we use the trigger voilation rules of
trigger body will not affect existing data.but in case of
constrinat will affect the exsting data also.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a database trigger?

784


What is a table partition?

782


What is varray in pl sql?

753


What is procedure explain with example?

699


Do we need to rebuild index after truncate?

690






How do I filter in sql profiler?

726


How many times can we commit in a loop?

735


What does sign mean sql?

756


What is sql and its types?

811


Define select, insert, create, delete, update, drop keywords

776


How can a pl sql block be executed?

678


What are crud methods?

726


Can we change the table name in sql?

697


What is the difference between stored procedure and view?

729


What are the parts of a basic sql query?

717