Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Limitations of a CHECK Constraint ?
- 5 Answers
- 19485 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 |
What is sequence?
What are Clusters ?
Can a View based on another View ?
Explain can a view based on another view?
What is key preserved table?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Explain index?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is a synonym? What are its various types?
What is a system tablespace?
What are the Characteristics of Data Files ?
What is the parameter mode that can be passed to a procedure?
Oracle General 
