CONSTRAINT

[kavithared]

HII,Any one can help me,
I need check the column values by using constraint.
Ex---ABC table
Column name STATUS
CHECK VALUES LIKE IF STATUS = 'A' ADMINISTRATOR
= 'S' STAFF
So any one can help me to write a check constraint abow column.
thanks
kavitha

[bensr]

From the examples:
CREATE TABLE Dept_tab (
Deptno NUMBER(3) PRIMARY KEY,
Dname VARCHAR2(15),
Loc VARCHAR2(15),
CONSTRAINT Dname_ukey UNIQUE (Dname, Loc),
CONSTRAINT LOC_CHECK1
CHECK (Loc IN ('NEW YORK', 'BOSTON', 'CHICAGO')));

[kavithared]

hiii,thanks
table abc
columnname-- status.
status should be like this

A-ADMINISTRATOR
S-STAFF
E-EXPIRED
S-SUSPEND
Above values should be valid by using "check" constraint.

any one give me syntax
thanks

[pando]

kavithared

why you keep on duplicating, or even tripling you threads???

what´s the problem