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: