RHNVISIBLESERVERGROUP
DDL scriptColumns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
ID | NUMBER(38) | N | YES | YES | YES | |
NAME | VARCHAR2(64) | N | YES | YES | YES | |
DESCRIPTION | VARCHAR2(1024) | N | YES | YES | YES | |
CURRENT_MEMBERS | NUMBER(38) | N | YES | YES | YES | |
GROUP_TYPE | NUMBER(38) | Y | YES | YES | YES | |
ORG_ID | NUMBER(38) | N | YES | YES | YES | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | YES | YES | YES | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | YES | YES | YES | |
Query:
Legend: string keyword reserved word operator
SELECT ID,NAME,DESCRIPTION,CURRENT_MEMBERS,GROUP_TYPE,ORG_ID,CREATED,MODIFIED
FROM rhnServerGroup SG
WHERE SG.group_type IS NULL