ALL_DOMAIN

3.183 ALL_DOMAIN_COLS

ALL_DOMAIN_COLS describes columns of the data use case domains accessible to the current user.

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

Related Views

DBA_DOMAIN_COLS describes columns of all data use case domains in the database.
USER_DOMAIN_COLS describes columns of 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
`DOMAIN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the use case domain
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the column
`COLUMN_ID`	`NUMBER`	`NOT NULL`	Column number in the use case 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 23ai.