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
- 7573 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 |
difference between bind variable and variable
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
How to count duplicated values in a column in oracle?
What is background process in Oracle?
Explain about functional dependency and its relation with table design?
Explain the difference between sql and oracle?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
What is data type in oracle?
What is a Sequence ?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
12. Display the client name in upper case only and in lower case only.
Explain the use of grant option in exp command.
Oracle General 
