[Home] [Help] [Dependency Information]

TABLE: MDSYS.OLS_DIR_CATEGORIES

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: SYS_C00246976

1. CATEGORY_ID
2. CATEGORY_TYPE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00246976	NORMAL	UNIQUE	SYSAUX	CATEGORY_ID CATEGORY_TYPE_ID
SYS_IL0000635036C00006$$	LOB	UNIQUE	SYSAUX

Foreign Keys

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

Columns

Query Text

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;

Dependencies

[top of page]

PUBLIC

XMLTYPE

SYS

STANDARD - show dependent code

XMLTYPE

MDSYS

SDO_OLS_DIRECTORY - show dependent code