Spacewalk DB Schema - View-RHNUSERTYPECOMMAVIEW

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

RHNUSERTYPECOMMAVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
USER_ID	NUMBER(38)	N	NO	NO	NO
IDS	VARCHAR2(4000)	Y	NO	NO	NO
LABELS	VARCHAR2(4000)	Y	NO	NO	NO
NAMES	VARCHAR2(4000)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
    uta.user_id,
    id_join(', ', uta.type_id_t),
    label_join(', ', uta.type_label_t),
    name_join(', ', uta.type_name_t)
from
    rhnUserTypeArray uta