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.

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 AI Database 26ai.

See Also: