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 schema-level triggers?
What are the ddl commands?
Is sql workbench free?
What are pl sql procedures?
How exception is different from error?
What is t-sql? : Transact sql
Is natural join and inner join same?
What is mdb stand for?
what is the difference between delete and truncate statement in sql? : Sql dba
Is keyword pl sql?
What is memory optimized table?
What are sql commands?
Can we use rowid as primary key?
What is server name sql?
What is sqlca in powerbuilder?
