RHNORGCHANNELTREEVIEW
DDL scriptColumns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
ID | NUMBER(38) | Y | NO | NO | NO | |
DEPTH | NUMBER(38) | Y | NO | NO | NO | |
NAME | VARCHAR2(256) | Y | NO | NO | NO | |
PADDED_NAME | VARCHAR2(258) | Y | NO | NO | NO | |
CHANNEL_ARCH_ID | NUMBER(38) | Y | NO | NO | NO | |
LAST_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
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 | |
END_OF_LIFE | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select ORG_ID,ID,DEPTH,NAME,PADDED_NAME,CHANNEL_ARCH_ID,LAST_MODIFIED,LABEL,PARENT_OR_SELF_LABEL,PARENT_OR_SELF_ID,END_OF_LIFE from (
select cfp.org_id as org_id,
c.id as id,
1 as depth,
c.name as name,
' ' || c.name as padded_name,
c.channel_arch_id as channel_arch_id,
c.last_modified as last_modified,
c.label as label,
c.label as parent_or_self_label,
c.id as parent_or_self_id,
c.end_of_life as end_of_life
from rhnChannel c,
rhnChannelFamilyMembers cfm,
rhnOrgChannelFamilyPermissions cfp
where cfp.channel_family_id = cfm.channel_family_id
and cfm.channel_id = c.id
and c.parent_channel is null
union
select cfp.org_id as org_id,
c.id as id,
2 as depth,
c.name as name,
'' || c.name as padded_name,
c.channel_arch_id as channel_arch_id,
c.last_modified as last_modified,
c.label as label,
pc.label as parent_or_self_label,
pc.id as parent_or_self_id,
c.end_of_life as end_of_life
from rhnChannel pc,
rhnChannel c,
rhnChannelFamilyMembers cfm,
rhnOrgChannelFamilyPermissions cfp
where cfp.channel_family_id = cfm.channel_family_id
and cfm.channel_id = c.id
and c.parent_channel = pc.id
) s order by parent_or_self_label, parent_or_self_id