[Home] [Help] [Dependency Information]
Object Name: | CDB_NESTED_TABLE_COLS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Columns of nested tables in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | |
TABLE_NAME | VARCHAR2 | (30) | Yes | Nested table name |
COLUMN_NAME | VARCHAR2 | (30) | Yes | Column name |
DATA_TYPE | VARCHAR2 | (106) | Datatype of the column | |
DATA_TYPE_MOD | VARCHAR2 | (3) | Datatype modifier of the column | |
DATA_TYPE_OWNER | VARCHAR2 | (30) | Owner of the datatype of the column | |
DATA_LENGTH | NUMBER | Yes | Length of the column in bytes | |
DATA_PRECISION | NUMBER | Length: decimal digits (NUMBER) or binary digits (FLOAT) | ||
DATA_SCALE | NUMBER | Digits to right of decimal point in a number | ||
NULLABLE | VARCHAR2 | (1) | Does column allow NULL values? | |
COLUMN_ID | NUMBER | Sequence number of the column as created | ||
DEFAULT_LENGTH | NUMBER | Length of default value for the column | ||
NUM_DISTINCT | NUMBER | The number of distinct values in the column | ||
LOW_VALUE | RAW | (1000) | The low value in the column | |
HIGH_VALUE | RAW | (1000) | The high value in the column | |
DENSITY | NUMBER | The density of the column | ||
NUM_NULLS | NUMBER | The number of nulls in the column | ||
NUM_BUCKETS | NUMBER | The number of buckets in histogram for the column | ||
LAST_ANALYZED | DATE | The date of the most recent time this column was analyzed | ||
SAMPLE_SIZE | NUMBER | The sample size used in analyzing this column | ||
CHARACTER_SET_NAME | VARCHAR2 | (44) | Character set name | |
CHAR_COL_DECL_LENGTH | NUMBER | Declaration length of character type column | ||
GLOBAL_STATS | VARCHAR2 | (3) | Are the statistics calculated without merging underlying partitions? | |
USER_STATS | VARCHAR2 | (3) | Were the statistics entered directly by the user? | |
AVG_COL_LEN | NUMBER | The average length of the column in bytes | ||
CHAR_LENGTH | NUMBER | The maximum length of the column in characters | ||
CHAR_USED | VARCHAR2 | (1) | C if the width was specified in characters, B if in bytes | |
V80_FMT_IMAGE | VARCHAR2 | (3) | Is column data in 8.0 image format? | |
DATA_UPGRADED | VARCHAR2 | (3) | Has column data been upgraded to the latest type version format? | |
HIDDEN_COLUMN | VARCHAR2 | (3) | Is this a hidden column? | |
VIRTUAL_COLUMN | VARCHAR2 | (3) | Is this a virtual column? | |
SEGMENT_COLUMN_ID | NUMBER | Sequence number of the column in the segment | ||
INTERNAL_COLUMN_ID | NUMBER | Internal sequence number of the column | ||
HISTOGRAM | VARCHAR2 | (15) | ||
QUALIFIED_COL_NAME | VARCHAR2 | (4000) | Qualified column name | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TABLE_NAME
, COLUMN_NAME
, DATA_TYPE
, DATA_TYPE_MOD
, DATA_TYPE_OWNER
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, NULLABLE
, COLUMN_ID
, DEFAULT_LENGTH
, NUM_DISTINCT
, LOW_VALUE
, HIGH_VALUE
, DENSITY
, NUM_NULLS
, NUM_BUCKETS
, LAST_ANALYZED
, SAMPLE_SIZE
, CHARACTER_SET_NAME
, CHAR_COL_DECL_LENGTH
, GLOBAL_STATS
, USER_STATS
, AVG_COL_LEN
, CHAR_LENGTH
, CHAR_USED
, V80_FMT_IMAGE
, DATA_UPGRADED
, HIDDEN_COLUMN
, VIRTUAL_COLUMN
, SEGMENT_COLUMN_ID
, INTERNAL_COLUMN_ID
, HISTOGRAM
, QUALIFIED_COL_NAME
, CON_ID
FROM SYS.CDB_NESTED_TABLE_COLS;
SYS.CDB_NESTED_TABLE_COLS does not reference any database object
SYS.CDB_NESTED_TABLE_COLS is referenced by following:
|
|
|