336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
1. Defines a condition
2. Not-Allowed expressions :
- CURRVAL, NEXTVAL, LEVEL, ROWNUM pseudocolumns
- SYSDATE, UID, USER, and USERENV functions
- Queries that refer to other values in other rows
3. A single column can have multiple CHECK constraints
2. Not-Allowed expressions :
- CURRVAL, NEXTVAL, LEVEL, ROWNUM pseudocolumns
- SYSDATE, UID, USER, and USERENV functions
- Queries that refer to other values in other rows
ex) .... , salary NUMBER(2) CONSTRAINT emp_salary_min
CHECK (salary > 0 ), .....
CHECK (salary > 0 ), .....
3. A single column can have multiple CHECK constraints
'Oracle' 카테고리의 다른 글
| Violating Constraint (0) | 2006.11.23 |
|---|---|
| Violating Constraint (0) | 2006.11.23 |
| CHECK Constraint (0) | 2006.11.23 |
| FOREIGN KEY Constraint (0) | 2006.11.23 |
| FOREIGN KEY Constraint (0) | 2006.11.23 |