RHNCHANNELTREEVIEW
DDL scriptColumns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
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 ID,DEPTH,NAME,PADDED_NAME,CHANNEL_ARCH_ID,LAST_MODIFIED,LABEL,PARENT_OR_SELF_LABEL,PARENT_OR_SELF_ID,END_OF_LIFE from (
select 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
where c.parent_channel is null
union
select 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
where c.parent_channel = pc.id
) S order by parent_or_self_label, parent_or_self_id