Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
- 2 Answers
- 6397 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 |
How to define a cusotmer as a supplier in ORACLE R12
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Why oracle is used?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What is a table index?
What is cluster Key ?
How to connect asp pages to oracle servers?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What are virtual columns?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
How can you use check constraints for self referential integrity?
What are steps required to ENTER DATA INTO DWH?
Oracle General 
