Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
- 2 Answers
- 6981 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 would you use to improve performance on an insert statement that places millions of rows into that table?
How to define and use table alias names in oracle?
how to join query for one source type is oracle another source type is sql server ?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
How to create tables for odbc connection testing?
What is using clause and give example?
What is the scope of a local variable?
What is columnar storage what is the advantage?
What is tns entry?
what is the syntax of SELECT command?
What is data block in Oracle?
What is archive log in Oracle?
Oracle General 
