3.180 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:

• "DBA_DOMAINS"

• "USER_DOMAINS"