What are the Limitations of a CHECK Constraint ?
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 insert all statement in sql
How do I use os authentication with weblogic jdriver for oracle and connection pools?
difference between imlicit cursor and explicit cursor ?
What is proxy method?
How to update a table row with a record?
8. Display the client name and order date for all orders using the natural join keywords.
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
What are the various types of snapshots ?
What is the meaning of recursive hints in oracle?
Tell me New Feature of Oracle 10g?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth