SH.DR$SUP TEXT IDX$I (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table SH.DR$SUP_TEXT_IDX$I

Columns[edit]

Column Data Type Nullable Default Description
TOKEN_TEXT VARCHAR2(64) not null
TOKEN_TYPE NUMBER(3, 0) not null
TOKEN_FIRST NUMBER(10, 0) not null
TOKEN_LAST NUMBER(10, 0) not null
TOKEN_COUNT NUMBER(10, 0) not null
TOKEN_INFO BLOB(4000) null

Indexes[edit]

Index Type Columns
DR$SUP_TEXT_IDX$X TOKEN_TEXT, TOKEN_TYPE, TOKEN_FIRST, TOKEN_LAST, TOKEN_COUNT

Check Constraints[edit]

Check Constraint Expression Description
SYS_C005233 "TOKEN_TEXT" IS NOT NULL
SYS_C005234 "TOKEN_TYPE" IS NOT NULL
SYS_C005235 "TOKEN_FIRST" IS NOT NULL
SYS_C005236 "TOKEN_LAST" IS NOT NULL
SYS_C005237 "TOKEN_COUNT" IS NOT NULL