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