[Home] [Help] [Dependency Information]
Object Name: | DBA_MD_COLUMNS |
---|---|
Object Type: | VIEW |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
MD_TABLE_NAME | VARCHAR2 | (128) | ||
COLUMN_NAME | VARCHAR2 | (128) | ||
DATA_TYPE | VARCHAR2 | (128) | ||
DATA_LENGTH | NUMBER | |||
DATA_PRECISION | NUMBER | |||
DATA_SCALE | NUMBER | |||
NDIM | NUMBER | |||
MAX_LEVEL | NUMBER | |||
NULLABLE | VARCHAR2 | (1) | ||
PARTITION_KEY | VARCHAR2 | (1) | ||
COLUMN_ID | NUMBER | |||
DEFAULT_LENGTH | NUMBER | |||
DATA_DEFAULT | LONG | (0) | ||
NUM_DISTINCT | NUMBER | |||
LOW_VALUE | RAW | (1000) | ||
HIGH_VALUE | RAW | (1000) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, MD_TABLE_NAME
, COLUMN_NAME
, DATA_TYPE
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, NDIM
, MAX_LEVEL
, NULLABLE
, PARTITION_KEY
, COLUMN_ID
, DEFAULT_LENGTH
, DATA_DEFAULT
, NUM_DISTINCT
, LOW_VALUE
, HIGH_VALUE
FROM MDSYS.DBA_MD_COLUMNS;
|
|
|