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
Explain the order of sql statement execution?
Why is partition used in sql?
How to get help at the sql prompt?
What is a pdo connection?
Are stored procedures faster than queries?
What is the use of double ampersand (&&) in sql queries? Give an example
What are triggers in sql?
What is query execution plan in sql?
What does fetching a cursor do?
What are pl/sql cursor exceptions?
What is difference between cursor and trigger?
what is schema? : Sql dba
Can one improve the performance of sql*loader? : aql loader
What is difference between primary and secondary key?
explain normalization concept? : Sql dba
