ALL_MEMBER_FIELDS_FOR_GROUP
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| GROUP_ID | NUMBER(38) | Y | NO | NO | NO | |
| FIELD_NAME | VARCHAR2(200.0) | Y | NO | NO | NO | |
| FIELD_TYPE | VARCHAR2(20.0) | Y | NO | NO | NO | |
| SORT_KEY | VARCHAR2(41.0) | Y | NO | NO | NO | |
Query:
select group_id, field_name, field_type, 'a' || sort_key as sort_key
from user_group_type_member_fields ugtmf, user_groups ug
where ugtmf.group_type = ug.group_type
union
select group_id, field_name, field_type, 'b' || sort_key as sort_key
from user_group_member_fields
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002