Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Limitations of a CHECK Constraint ?
- 5 Answers
- 19029 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 are triggers?Where are they used?
How to empty your oracle recycle bin?
How to convert characters to times in oracle?
How to count groups returned with the group by clause in oracle?
How to use windows user to connect to the server?
Describe Referential Integrity ?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
How to delete multiple rows from a table in oracle?
what is dynamic SGA and static SGA
What is a Data Dictionary ?
Give the various rollback segment states.
Oracle General 
