3.196 ALL_DOMAINS

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

Related Views

  • DBA_DOMAINS describes all data use case domains in the database.

  • USER_DOMAINS describes the data use case domains owned by 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 Database 23ai.

See Also: