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
Is there a function to split a string in plsql?
Explain an exception?
How do I spool to a csv formatted file using sqlplus?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is the difference between count (*), count (expression), count (distinct expression)?
What is recovery manager(rman) backup in Oracle?
What is the oracle implicit cursor?
How to delete a column in an existing table?
Give the advantages and disadvantages of clusters.
What are the limitations of check constraint?
what is Single Byte Overhead...?
How do we get field detail of a table?
How to retrieve the count of updated rows?
How do I reset a sequence in oracle?
How to find out what oracle odbc drivers are installed?
