OWNER

VARCHAR2(128)

NOT NULL

Owner of the hierarchy

HIER_NAME

VARCHAR2(128)

NOT NULL

Name of the hierarchy

COLUMN_NAME

VARCHAR2(128)

NOT NULL

Name of the column

ROLE

VARCHAR2(4)

• KEY

• AKEY

• HIER

• PROP

DATA_TYPE

VARCHAR2(106)

Datatype of the column

DATA_LENGTH

NUMBER

NOT NULL

Length of the column (in bytes)

DATA_PRECISION

NUMBER

Decimal precision for the NUMBER datatype; binary precision for the FLOAT datatype, NULL for all other datatypes

DATA_SCALE

NUMBER

Number of digits to the right of the decimal point in a number

NULLABLE

CHAR(1)

Indicates whether a column allows NULL values; the value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY

CHARACTER_SET_NAME

VARCHAR2(44)

Name of the character set:

• CHAR_CS

• NCHAR_CS

CHAR_COL_DECL_LENGTH

NUMBER

Declaration length of the character type column

CHAR_USED

VARCHAR2(1)

Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C), or whether the datatype is not any of the following (NULL):

• CHAR

• VARCHAR2

• NCHAR

• NVARCHAR2

ORDER_NUM

NUMBER

NOT NULL

Order of the column, with attributes first in the order specified in the definition of the hierarchy followed by hierarchical attributes

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).

EDITION_NAME

VARCHAR2(128)

Name of the application edition where the hierarchy is defined