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
- 7643 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 commit the current transaction in oracle?
What is key preserved table?
how do u setup a replication site?
How do we get field detail of a table?
How to delete an existing row from a table in oracle?
What is a named program unit?
What to do if dba lost the system password?
How do I learn what codesets are available in oracle?
How to create a new view in oracle?
What is hash cluster in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Where are the settings stored for each instance in oracle?
What is data file?
What is materialized view in Oracle?
How to write a query with a right outer join in oracle?
