Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Limitations of a CHECK Constraint ?
- 5 Answers
- 19327 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priyanka
conditions mentioned in the CHECK constraint must be a
boolean exp,they cannot be subqueries or sequences n
cannot include the SYSDATE,UID,USER, USERNV SQLfunctions
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / pkd
with check constraint, you can not use pseudo column
(sysdate) function
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / surya
It is used to avoid invalid and inconsistence data into the
data base table.
For example if you specify like this
sal int Check(sal>=1000)
and trying to insert value below 1000 in the sal
column,they won't accept you.That means it restrict the
data in the database table.
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / 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 |
Answer / ratnarao
The check consttraint should be with in the two boundaries
(min value to max value).
| Is This Answer Correct ? | 5 Yes | 9 No |
Youre getting high busy buffer waits - how can you find whats causing it?
Is oracle an operator?
How can you Enforce Referential Integrity in snapshots ?
How to get maxsal , minsal, ename department wise in single query
What is mean by Program Global Area (PGA) ?
Can sub procedure/function be called recursively?
How to test null values?
What would you do if a database crashes in production?
What is a snapshot log?
How do you bind variables in oracle?
How to add a new column to an existing table with a default value?
difference between truncate and delete ,drop?
Oracle General 
