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
Printable View
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
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')));
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
kavithared
why you keep on duplicating, or even tripling you threads???
what´s the problem