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
- 7781 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
What is oracle analytical function?
What is bulk load in oracle?
How to pass a parameter to a cursor in oracle?
How many file formats are supported to export data?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Can we protect our pl/sql source code?
What happens to the current transaction if the session is killed?
How to see the table columns used in an index?
What is memory advisor in Oracle?
Can we connect to ORACLE db using Windows Authentication?
How to loop through a cursor variable?
What are the roles of dba?
How to shutdown your 10g xe server?
Compare and contrast between sql and sql server and explain its various functions?
Explain what are the uses of rollback segment?
