Oracle
CHECT Constraint
Figo Kim
2006. 9. 3. 00:22
- Defines a condition that each row must satisfy
- The following expressions are not allowed:
- References to CURRVAL, NEXTVAL, LEVEL, and ROWNUM pseudocolumns
- Call to SYSDATE, UID, USER, and USERENV functions
- Queries that refer to other values in other rows
..., salary NUMBER(2)
CONSTRAINT emp_salary_min
CHECK (salary > 0),...