[Home] [Help] [Dependency Information]
Object Name: | OLS_DIR_CATEGORIES |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00278896 | NORMAL | UNIQUE | SYSAUX |
CATEGORY_ID
CATEGORY_TYPE_ID |
SYS_IL0001108213C00006$$ | LOB | UNIQUE | SYSAUX |
Table | |
Foreign Table | Foreign Key Column | OLS_DIR_CATEGORIES | OLS_DIR_CATEGORIES |
OLS_DIR_CATEGORIES
PARENT_ID
OLS_DIR_CATEGORIES CATEGORY_TYPE_ID |
OLS_DIR_CATEGORIES | OLS_DIR_CATEGORY_TYPES | OLS_DIR_CATEGORIES CATEGORY_TYPE_ID | OLS_DIR_CATEGORIES | OLS_DIR_CATEGORIES |
OLS_DIR_CATEGORIES
PARENT_ID
OLS_DIR_CATEGORIES CATEGORY_TYPE_ID |
OLS_DIR_CATEGORIZATIONS | OLS_DIR_CATEGORIES |
OLS_DIR_CATEGORIZATIONS
CATEGORY_ID
OLS_DIR_CATEGORIZATIONS CATEGORY_TYPE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_ID | VARCHAR2 | (32) | Yes | |
CATEGORY_TYPE_ID | NUMBER | Yes | ||
CATEGORY_NAME | VARCHAR2 | (128) | Yes | |
PARENT_ID | VARCHAR2 | (32) | ||
PARAMETERS | XMLTYPE | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_ID
, CATEGORY_TYPE_ID
, CATEGORY_NAME
, PARENT_ID
, PARAMETERS
FROM MDSYS.OLS_DIR_CATEGORIES;
|
|
|