1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?

Question Posted / sandeep desai

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


Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

529

Explain integrity constraint?

646

How to create a new table in oracle?

591

How many categories of data types in oracle?

605

Can we use bind variables in oracle stored procedure?

490




What is index in Oracle?

594

What is java oracle used for?

526

What is a partition in oracle?

546

How do I use unicode codesets with the weblogic jdriver for oracle driver?

552

How to build data dictionary view an new database?

532

What is a package in oracle?

566

What is the data pump import utility?

585

How to omit columns with default values in insert statement in oracle?

579

How many categories of data types?

574

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1804