Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
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 many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the data types in oracle?
How to call a sub procedure?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between 10g OEM and 11g OEM?
How to unlock the sample user account in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is a view and how is it different from a table?
What is the max number of columns in an oracle table?
20. Using a set operator, display the client number of all clients who have never placed an order.
How data locks are respected in oracle?
Explain the use of parfile option in exp command.
Why packages are used in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....