[Home] [Help] [Dependency Information]
Object Name: | LOGMNR_TAB_COLS_SUPPORT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOGMNR_UID | NUMBER | (22) | ||
OBJ# | NUMBER | (22) | Yes | |
OWNER# | NUMBER | (22) | ||
OWNER | VARCHAR2 | (128) | Yes | |
TABLE_NAME | VARCHAR2 | (128) | ||
COLUMN_NAME | VARCHAR2 | (128) | ||
TYPE# | NUMBER | (22) | ||
DATA_TYPE | VARCHAR2 | (128) | ||
DATA_TYPE_MOD | VARCHAR2 | (3) | ||
DATA_TYPE_OWNER | VARCHAR2 | (128) | ||
DATA_LENGTH | NUMBER | (22) | ||
DATA_PRECISION | NUMBER | (22) | ||
DATA_SCALE | NUMBER | (22) | ||
NULLABLE | VARCHAR2 | (1) | ||
COLUMN_ID | NUMBER | |||
CHARACTER_SET_NAME | VARCHAR2 | (44) | ||
CHAR_COL_DECL_LENGTH | NUMBER | |||
CHAR_USED | VARCHAR2 | (1) | ||
V80_FMT_IMAGE | VARCHAR2 | (3) | ||
HIDDEN_COLUMN | VARCHAR2 | (3) | ||
VIRTUAL_COLUMN | VARCHAR2 | (3) | ||
SEGMENT_COLUMN_ID | NUMBER | |||
INTERNAL_COLUMN_ID | NUMBER | (22) | ||
QUALIFIED_COL_NAME | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT LOGMNR_UID
, OBJ#
, OWNER#
, OWNER
, TABLE_NAME
, COLUMN_NAME
, TYPE#
, DATA_TYPE
, DATA_TYPE_MOD
, DATA_TYPE_OWNER
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, NULLABLE
, COLUMN_ID
, CHARACTER_SET_NAME
, CHAR_COL_DECL_LENGTH
, CHAR_USED
, V80_FMT_IMAGE
, HIDDEN_COLUMN
, VIRTUAL_COLUMN
, SEGMENT_COLUMN_ID
, INTERNAL_COLUMN_ID
, QUALIFIED_COL_NAME
FROM SYS.LOGMNR_TAB_COLS_SUPPORT;
|
|
|