What is the Diff b/w Constraints and Trigeer

Answer Posted / shekar

Triggers: It checks the condition and Performs some action
eg: it checks and fires before or after insert or update
or delete

Constriants: it checks the condition
eg: suppose NotNull constraint.It jst doesn't allow null
values.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does oracle roll back the transaction on an error?

539


What pl/sql package consists of?

638


What are the different datatypes available in PL/SQL?

571


Can we use ddl commands in pl sql?

563


What are the two characteristics of a primary key?

495






What are the different types of triggers?

595


When you have to use a default "rollback to" savepoint of plvlog?

728


how to delete an existing column in a table? : Sql dba

555


Can there be more than one function with a similar name in a pl/sql block?

551


how to shut down the server with 'mysqladmin'? : Sql dba

549


How to return an array from java to pl/sql?

595


Is inner join faster than left join?

640


List and explain the different types of join clauses supported in ansi-standard sql?

827


What is a system versioned table?

538


How to display the current date in sql?

603