What is the Diff b/w Constraints and Trigeer

Answer Posted / manoranan sethy

Constraints are restrict the invalid data before invoke into the database whereas trigger restrict the invalid transaction.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

618


what are tables and fields? : Sql dba

575


how can I make a script that can be bi-language (supports english, german)? : Sql dba

532


what are aggregate and scalar functions? : Sql dba

548


how to shutdown mysql server? : Sql dba

563






What is cursor in pl sql?

574


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

522


What is nvl?

607


What is difference between mysql and postgresql?

509


Is sql database free?

523


Which command is used to call a stored procedure?

495


What is the sql case statement?

568


What are some emotional triggers?

568


how to include numeric values in sql statements? : Sql dba

555


what are the differences between char and nchar? : Sql dba

590