RHNCHANNELFAMILYOVERVIEW
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | N | YES | YES | YES | |
| ID | NUMBER(38) | N | NO | NO | NO | |
| NAME | VARCHAR2(128) | N | NO | NO | NO | |
| URL | VARCHAR2(128) | N | NO | NO | NO | |
| LABEL | VARCHAR2(128) | N | NO | NO | NO | |
| CURRENT_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
| MAX_MEMBERS | NUMBER(38) | Y | YES | YES | YES | |
| HAS_SUBSCRIPTION | NUMBER(38) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select pcf.org_id org_id,
f.id id,
f.name name,
f.product_url url,
f.label label,
NVL(pcf.current_members,0) current_members,
pcf.max_members max_members,
1 has_subscription
from rhnChannelFamily f,
rhnPrivateChannelFamily pcf
where pcf.channel_family_id = f.id