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 are the types of optimization?
Is it mandatory for the primary key to be given a value when a new record is inserted?
how to concatenate two character strings? : Sql dba
What are primary key and foreign key and how they work?
What is scalar function?
What is dynamic sql in pl sql?
what are all the different types of indexes? : Sql dba
What is view? Can we update view
How to fetch alternate records from a table?
What is full join?
How to select 10 records from a table?
How do I tune a sql query?
What is the reports view in oracle sql developer?
how to use in conditions? : Sql dba
Can we create table inside stored procedure?
