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 |
How to join two tables in a single query using oracle?
How to get execution statistics reports on query statements?
What is an oracle wallet?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
What is oracle data type?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
What the is the diff between local index and global index. give some example.
What are Clusters ?
Explain the use of constraints option in exp command.
What are inner join and outer join?
Is oracle a language?