|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| REVENUE_ID | NUMBER(38) | N | YES | YES | YES | |
| REVENUE | VARCHAR2(50.0) | N | YES | YES | YES |
select category_id as revenue_id, category as revenue from categories where category_type = 'Intranet Annual Revenue'