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
What is sqlcommand?
What is on delete restrict?
Why do we need cursor in pl sql?
Which is faster count (*) or count 1?
Does sql support programming?
What are the main features of cursor?
Are there any features that are decommissioned in 11g that are not present in 11g?
What if we write return in procedure?
What is the difference between the implicit and explicit cursors?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Why truncate is faster than delete?
Mention what plvcmt and plvrb does in pl/sql?
What is sql engine in oracle?
What is cartesian join in sql?
What is a native sql query?