Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Limitations of a CHECK Constraint ?
- 5 Answers
- 19343 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 |
Is truncate autocommit in oracle?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What are data pump export and import modes?
what are actual and formal parameters?
What is integrity and what is constraint??Explain with example
How to upsert (update or insert into a table)?
How can Oracle users be audited?
What is the data type of dual table?
How a tablespace is related to data files?
how to store only time in a data base table
if you ctreate table identity
What is Oracle table?
Oracle General 
