Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vijay kumar jakkam
1. A CHECK constraint evaluates to TRUE when the resulting value of the CHECK constraint expression is unknown, e.g. when the expression contains NULL.
Example: A CHECK constraint that enforces the value of a particular column to be >0 evaluates to TRUE if NULL passed while inserting.
2. CHECK Constraints are not evaluated for delete statements.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different types of modules in oracle forms?
How to export several tables together?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
candidate key is subset of super key but not vice-verse explain
What do you mean by a database transaction & what all tcl statements are available in oracle?
How can we force the database to use the user specified rollback segment?
How to insert multiple rows with one insert statement in oracle?
How do I recompile a procedure in oracle?
What are the execution control statements in oracle?
How to call a stored function with parameters?
How to create a new tablespace in oracle?
What is the exact use of Collections?
How to change program global area (pga) in oracle?
Can a parameter be passed to a cursor?
Explain the features of oracle?
