RHNAVAILABLECHANNELS
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_ID | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_DEPTH | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_NAME | VARCHAR2(256) | Y | NO | NO | NO | |
| CHANNEL_ARCH_ID | NUMBER(38) | Y | NO | NO | NO | |
| PADDED_NAME | VARCHAR2(258) | Y | NO | NO | NO | |
| LAST_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
| CHANNEL_LABEL | VARCHAR2(128) | Y | NO | NO | NO | |
| PARENT_OR_SELF_LABEL | VARCHAR2(128) | Y | NO | NO | NO | |
| PARENT_OR_SELF_ID | NUMBER(38) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select
ct.org_id,
ct.id,
CT.depth,
CT.name,
CT.channel_arch_id,
CT.padded_name,
CT.last_modified,
CT.label,
CT.parent_or_self_label,
CT.parent_or_self_id
from
rhnOrgChannelTreeView CT
UNION ALL
select
ct.org_id,
ct.id,
CT.depth,
CT.name,
CT.channel_arch_id,
CT.padded_name,
CT.last_modified,
CT.label,
CT.parent_or_self_label,
CT.parent_or_self_id
from
rhnSharedChannelTreeView CT