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
- 7927 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to convert characters to times in oracle?
Why do we need oracle client?
How to change user password in oracle?
What is logical backup in oracle?
What is a trigger and what are its types in oracle?
What is a connect identifier?
How many types of synonyms in Oracle?
How to invoke the original export import utilities?
How to count groups returned with the group by clause in oracle?
What are the restrictions on external table columns?
How to open and close an explicit cursor in oracle?
Explain a segment?
What do you mean by a tablespace?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
defination of bitmap index
