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
- 7734 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 |
find out first highest salary?
10 Answers Verinon Technology Solutions,
How to create lov dynamically at runtime & attach to text field?
Explain what are the different type of segments?
Difference between open_form and call_form in oracle.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is a View ?
what is exact difference between drop and truncate table.
What is an oracle transaction?
25. Display the client number and the value of the highest value order placed by that client.
What is a shared pool?
How to do clean up if create database failed?
how to we delete a row using varray
Oracle General 
