How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)

Oracle Apps Interview Questions › Category: SQL › How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)
0 Vote Up Vote Down
Questions Master asked 9 years ago

How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 9 years ago

ALTER TABLE emp ADD CONSTRAINT chk_001 CHECK(sal<=10000);