Oracle

CHECT Constraint

Figo Kim 2006. 9. 3. 00:22
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
  • 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),...


'Oracle' 카테고리의 다른 글

ALTER TABLE statement  (0) 2006.09.03
ALTER TABLE statement  (0) 2006.09.03
CHECT Constraint  (0) 2006.09.03
Datetime Data Types (2)  (0) 2006.09.02
Datetime Data Types (2)  (0) 2006.09.02