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
- 7771 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 |
How many data types are supported?
Explain the difference between sap and oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is private procedure oracle?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
How to call a trigger inside a stored procedure?Give an example.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
sql query to get zero records from a table
Explain implicit cursor.
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
How to pass a parameter to a cursor in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Oracle General 
