Interested to Buy Any Domain ? << Click Here >> for more details...
Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
- 2 Answers
- 7782 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep desai
No.
Eg:-
Consider Table emp
Assume there are only 5 records in emp
and in emp_sal column values are (1200,1400,4500,2000).
Now if I try to create a check constraint on emp_sal column
for the range between 2000 and 4000 then an error is thrown
since values below this range also exist in emp_sal column.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is a package in oracle?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is BBED in Oracle?
What is Database Buffers ?
What happens if you lost a data file?
What is merge in oracle?
What is the purpose of a cluster?
How to create tables for odbc connection testing?
How can I create database in oracle?
Explain the dml?
How to pass parameters to procedures in oracle?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Oracle General 
