USER_MVIEW_KEYS

Description of the columns that appear in the list of a materialized view created by the user

Columns
   ___________________________
 
   GROUP BY OWNER
      Owner of the materialized view
   GROUP BY MVIEW_NAME
      Name of the materialized view
   GROUP BY POSITION_IN_SELECT
      Position of this key within the SELECT list
   GROUP BY CONTAINER_COLUMN
      Name of the column in the container table
   GROUP BY DETAILOBJ_OWNER
      Owner of the detail object
   GROUP BY DETAILOBJ_NAME
      Name of the detail object
   GROUP BY DETAILOBJ_ALIAS
      Alias of the detail object
   GROUP BY DETAILOBJ_TYPE
      Type of the detail object: VIEW or TABLE
   GROUP BY DETAILOBJ_COLUMN
      Name of the detail object column

Related:


© Copyright SS64.com 1999-2014
Some rights reserved