|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| DEPARTMENT_ID | NUMBER(38) | N | YES | YES | YES | |
| DEPARTMENT | VARCHAR2(50.0) | N | YES | YES | YES |
select category_id as department_id, category as department from categories where category_type = 'Intranet Department'