ALL_DOMAINS

ALL_DOMAINS describes the data use case domains accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the use case domain
NAME VARCHAR2(128) NOT NULL Name of the use case domain
COLS NUMBER NOT NULL Number of columns in the use case domain
DISCRIMINANTCOLS NUMBER   For flexible domains, the number of discriminant columns in the use case domain. Otherwise, 0.
BUILTIN BOOLEAN   Indicates whether the use case domain is built-in (TRUE) or not (FALSE)
DATA_DISPLAY CLOB   Text of the DISPLAY expression for the use case domain
DISPLAY_LENGTH NUMBER  

Length of the DISPLAY expression for the use case domain (in bytes)

Null if a DISPLAY expression was not specified.

DATA_ORDER CLOB   Text of the ORDER expression for the use case domain
ORDER_LENGTH NUMBER  

Length of the ORDER expression for the use case domain (in bytes)

Null if an ORDER expression was not specified.

SELECTOR CLOB   For flexible domains, the text of the domain selector expression. Otherwise, null.
SELECTOR_LENGTH NUMBER   For flexible domains, the length of the domain selector expression (in bytes). Otherwise, null.
TYPE VARCHAR2(10)  

Use case domain type:

  • ENUMERATED

  • FLEXIBLE

Note: This view is available starting with Oracle AI Database 26ai.

See Also: