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
- 7919 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 are the sql clauses supported in the link property sheet ?
What is the relationship among database, tablespace and data file?
How to delete all rows a table in oracle?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What are the restrictions on external table columns?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Youre getting high busy buffer waits - how can you find whats causing it?
How to join two tables in a single query using oracle?
How to see free space of each tablespace?
Explain what does a control file contain?
Give the various rollback segment states.
how to join query for one source type is oracle another source type is sql server ?
Oracle General 
