2.153 ALL_HIER_CLASS
ALL_HIER_CLASS
describes the classifications of the hierarchies accessible to the current user.
Related Views
-
DBA_HIER_CLASS
describes the classifications of all hierarchies in the database. -
USER_HIER_CLASS
describes the classifications of the hierarchies owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the hierarchy |
|
|
|
Name of the hierarchy |
|
|
|
Classification associated with the hierarchy |
|
|
|
Value of the classification or |
|
|
|
NLS_LANGUAGE value associated with the classification or |
|
|
|
Order of the classification in the list of classifications associated with the hierarchy |
|
|
|
The ID of the container where the data originates. Possible values include:
|
Note:
This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).
See Also: