336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
To find the names of the columns to which a constraint applies.
DESCRIBE user_cons_columns;
- The name of the owner of a constraint
- The name of the constraint,
- Table name
- The names of the columns with the constraint
- The original position of column or attribute in the definition of the object
SELECT constraint_name, column_name FROM user_cons_columns
WHERE table_name = 'EMPLOYEES';
WHERE table_name = 'EMPLOYEES';
* A constraint may apply to more than one column.
** Join between USER_CONSTRAINTS and USER_CONS_COLUMNS
'Oracle' 카테고리의 다른 글
| View Information (0) | 2006.11.27 |
|---|---|
| Constraint Information (column level) (0) | 2006.11.27 |
| Constraint Information (table level) (0) | 2006.11.27 |
| Constraint Information (table level) (0) | 2006.11.27 |
| Column Information (0) | 2006.11.27 |