Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
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 does `(+)` do in a where clause?
What is an UTL_FILE.What are different procedures and functions associated with it?
What is the difference between postgresql and oracle?
What is difference between a formal and an actual parameter?
How to install oracle odbc drivers?
Can group functions be mixed with non-group selection fields?
What is a Database instance ? Explain?
Describe Referential Integrity ?
is database gud carrier option??
What is the Tune Query
How to lock and unlock a user account in oracle?
What is raw datatype?