3.178 ALL_DOMAIN_COLS

ALL_DOMAIN_COLS describes columns of the application usage domains accessible to the current user.

This view displays domain column attributes. Domain columns with alternative data types are displayed for each possible data type.

Related Views

  • DBA_DOMAIN_COLS describes columns of all application usage domains in the database.

  • USER_DOMAIN_COLS describes columns of the application usage domains owned by the current user.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the domain

DOMAIN_NAME

VARCHAR2(128)

NOT NULL

Name of the domain

COLUMN_NAME

VARCHAR2(128)

NOT NULL

Name of the column

COLUMN_ID

NUMBER

NOT NULL

Column number in the domain

DATA_TYPE_ID

NUMBER

NOT NULL

Indicates whether this row represents the primary (1) or secondary (2) data type specification for the column

DATA_TYPE

VARCHAR2(106)

Data type of the column

DATA_LENGTH

NUMBER

Length of the column (in bytes)

DATA_PRECISION

NUMBER

Decimal precision for NUMBER data type; binary precision for FLOAT data type; null for all other data types

DATA_SCALE

NUMBER

Digits to the right of the decimal point in a number; null for all other data types

NULLABLE

VARCHAR2(1)

Indicates whether a column allows NULLs. The value is N if there is a NOT NULL constraint on the column.

DATA_DEFAULT

CLOB

Default value for the column

DEFAULT_LENGTH

NUMBER

Length of the default value for the column (in bytes)

DEFAULT_ON_NULL

VARCHAR2(3)

Indicates whether the column has DEFAULT ON NULL for INSERT semantics (YES) or not (NO)

DEFAULT_ON_NULL_UPD

VARCHAR2(3)

Indicates whether the column has DEFAULT ON NULL for UPDATE semantics (YES) or not (NO)

CHARACTER_SET_NAME

VARCHAR2(44)

For character type columns, the name of the character set for the column:

  • CHAR_CS

  • NCHAR_CS

CHAR_COL_DECL_LENGTH

NUMBER

For character type columns, the declared length of the column (in bytes)

COLLATION

VARCHAR2(100)

For character type columns, the collation for the column

If a collation was not specified, the value of this column is null.

EXACT

BOOLEAN

Indicates whether the column data type specification is strict (TRUE) or not (FALSE)

CHAR_LENGTH

NUMBER

 

For character type columns, the length of the column (in characters)

DISCRIMINANT

BOOLEAN

 

Indicates whether the column is a discriminant column in a flexible domain (TRUE) or not (FALSE)

Note:

This view is available starting with Oracle Database 23c.