Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
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 |
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What is Database Link ?
How to unlock the sample user account in oracle?
What is control file used for?
How to drop a stored function?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
Please explain oracle left join with an example?
What is STATSPACK tool?
How to set a transaction to be read only in oracle?
Please explain oracle data types with examples?
How would you extract DDL of a table without using a GUI tool?
What language does oracle use?