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
what is subquery? : Sql dba
How do I run a program in pl sql?
difference between anonymous blocks and sub-programs.
What packages(if any) has oracle provided for use by developers?
how to use regular expression in pattern match conditions? : Sql dba
Explain locks? : Transact sql
Is vs as in pl sql?
How many types of indexes are there in sql?
what is the difference between char_length and length? : Sql dba
What is difference between stored procedures and application procedures?
What are pl/sql packages?
Can we use distinct and group by together?
Does access use sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
What can I use instead of union in sql?
