[Home] [Help] [Dependency Information]
Object Name: | KU$_M_VIEW_VIEW_BASE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VERS_MAJOR | CHAR | (1) | ||
VERS_MINOR | CHAR | (1) | ||
SOWNER | VARCHAR2 | (128) | ||
VNAME | VARCHAR2 | (128) | ||
TNAME | VARCHAR2 | (128) | ||
MOWNER | VARCHAR2 | (128) | ||
MASTER | VARCHAR2 | (128) | ||
MLINK | VARCHAR2 | (128) | ||
BASE_OBJ_NUM | NUMBER | |||
SNAPSHOT | VARCHAR2 | (19) | ||
SNAPID | NUMBER | |||
AUTO_FAST | VARCHAR2 | (8) | ||
AUTO_FUN | VARCHAR2 | (200) | ||
AUTO_DATE | VARCHAR2 | (19) | ||
USLOG | VARCHAR2 | (128) | ||
STATUS | NUMBER | |||
MASTER_VERSION | NUMBER | |||
TABLES | NUMBER | |||
FLAG | NUMBER | |||
FLAG2 | NUMBER | |||
FLAG3 | NUMBER | |||
LOBMASKVEC | RAW | (255) | ||
MAS_ROLL_SEG | VARCHAR2 | (128) | ||
RSCN | NUMBER | |||
INSTSITE | NUMBER | |||
FLAVOR_ID | NUMBER | |||
OBJFLAG | NUMBER | |||
SNA_TYPE_OWNER | VARCHAR2 | (128) | ||
SNA_TYPE_NAME | VARCHAR2 | (128) | ||
MAS_TYPE_OWNER | VARCHAR2 | (128) | ||
MAS_TYPE_NAME | VARCHAR2 | (128) | ||
PARENT_SOWNER | VARCHAR2 | (128) | ||
PARENT_VNAME | VARCHAR2 | (128) | ||
QUERY_LEN | NUMBER | |||
QUERY_TXT | CLOB | (4000) | ||
PARSED_QUERY_TXT | XMLTYPE | (64) | ||
QUERY_VCNT | KU$_VCNT | (0) | ||
REL_QUERY | CLOB | (4000) | ||
LOC_ROLL_SEG | VARCHAR2 | (128) | ||
GLOBAL_DB_NAME | VARCHAR2 | (4000) | ||
SYN_COUNT | NUMBER | |||
SRT_LIST | KU$_M_VIEW_SRT_LIST_T | (64) | ||
MFLAGS | NUMBER | |||
XPFLAGS | NUMBER | |||
ZMAPSCALE | NUMBER | |||
EVALEDITION_NUM | NUMBER | |||
UNUSABLEBEF_NUM | NUMBER | |||
UNUSABLEBEG_NUM | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT VERS_MAJOR
, VERS_MINOR
, SOWNER
, VNAME
, TNAME
, MOWNER
, MASTER
, MLINK
, BASE_OBJ_NUM
, SNAPSHOT
, SNAPID
, AUTO_FAST
, AUTO_FUN
, AUTO_DATE
, USLOG
, STATUS
, MASTER_VERSION
, TABLES
, FLAG
, FLAG2
, FLAG3
, LOBMASKVEC
, MAS_ROLL_SEG
, RSCN
, INSTSITE
, FLAVOR_ID
, OBJFLAG
, SNA_TYPE_OWNER
, SNA_TYPE_NAME
, MAS_TYPE_OWNER
, MAS_TYPE_NAME
, PARENT_SOWNER
, PARENT_VNAME
, QUERY_LEN
, QUERY_TXT
, PARSED_QUERY_TXT
, QUERY_VCNT
, REL_QUERY
, LOC_ROLL_SEG
, GLOBAL_DB_NAME
, SYN_COUNT
, SRT_LIST
, MFLAGS
, XPFLAGS
, ZMAPSCALE
, EVALEDITION_NUM
, UNUSABLEBEF_NUM
, UNUSABLEBEG_NUM
FROM SYS.KU$_M_VIEW_VIEW_BASE;
|
|
|