Table: ALL_MVIEW_KEYS
Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user
Column Name | Description |
---|---|
CONTAINER_COLUMN | Name of the column in the container table |
DETAILOBJ_ALIAS | Alias of the detail object |
DETAILOBJ_COLUMN | Name of the detail object column |
DETAILOBJ_NAME | Name of the detail object |
DETAILOBJ_OWNER | Owner of the detail object |
DETAILOBJ_TYPE | Type of the detail object: VIEW or TABLE |
MVIEW_NAME | Name of the materialized view |
OWNER | Owner of the materialized view |
POSITION_IN_SELECT | Position of this key within the SELECT list |