ALL_ATTRIBUTE_DIM_ORDER_ATTRS

ALL_ATTRIBUTE_DIM_ORDER_ATTRS describes the order attributes of the attribute dimensions accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the attribute dimension
DIMENSION_NAME VARCHAR2(128) NOT NULL Name of the attribute dimension
LEVEL_NAME VARCHAR2(128)   Name of the level to order or the name of the level that has the ORDER BY clause
AGG_FUNC VARCHAR2(3)  

Aggregation function of the ORDER BY clause:

  • MIN

  • MAX
ATTRIBUTE_NAME VARCHAR2(128)   Name of the order attribute
ORDER_NUM NUMBER NOT NULL Order number of the attribute in the list of order attributes
CRITERIA VARCHAR2(4)  

Criteria of the ordering, either ascending or descending:

  • ASC

  • DESC
NULLS_POSITION VARCHAR2(5)  

Position of ORDER BY values in the orderings:

  • FIRST

  • LAST
ORIGIN_CON_ID NUMBER  

The ID of the container where the data originates. Possible values include:

  • 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

  • n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root).

See Also: