Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saraswathi muthuraman
TO apply business rule we are using Constraints and trigger.
If we have any computation and validation over the
calculated value we have choose "trigger".
Direct validation like the column should not contain null
values then you can choose Constraints.
Constraints : NOT NULL,UNIQUE,PRIMARY KEY,CHECK,REFERENCE
Trigger effected only those row after which trigger applied
but constraint effected all row of table .
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
How do you update sql?
What is sql*loader and what is it used for?
Does sql*plus have a pl/sql engine?
What steps server process has to take to execute an update statement?
How do I count rows in sql?
How to run sql*plus commands in sql developer?
What is the order of sql select?
What is sql constant?
What is the purpose of my sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Why do we need cursors in pl sql?
Define concurrency control. : Transact sql
Differentiate between % rowtype and type record.
What is the purpose of normalization?
Explain the select statement in sql?
