Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
- 2 Answers
- 6341 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 public synonym?
What is merge statement used for?
what is a cartition product?
How to install oracle odbc drivers?
What is a nested table?
difference between oracle8i and oracle9i
How to revoke create session privilege from a user in oracle?
What is the data pump import utility?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
How to specify default values in insert statement using oracle?
how to get the no employee in each department including the dept which has 0 employee
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Oracle General 
