RHNCHANNELFAMILYPERMISSIONS
DDL scriptColumns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
CHANNEL_FAMILY_ID | NUMBER(38) | Y | NO | NO | NO | |
ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select channel_family_id,
to_number(null, null) as org_id,
created,
modified
from rhnPublicChannelFamily
union
select channel_family_id,
org_id,
created,
modified
from rhnPrivateChannelFamily