DBA Data[Home] [Help] [Dependency Information]


TABLE: CTXSYS.DR$SQE

Object Details
Object Name: DR$SQE
Object Type: TABLE
Owner: CTXSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_486848
  1. ColumnSQE_OWNER#
  2. ColumnSQE_NAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000486848C00003$$ LOB UNIQUE TablespaceCTXD
SYS_IOT_TOP_486848 IOT - TOP UNIQUE TablespaceCTXD ColumnSQE_OWNER#
ColumnSQE_NAME
Columns
Name Datatype Length Mandatory Comments
SQE_OWNER# NUMBER
Yes
SQE_NAME VARCHAR2 (30) Yes
SQE_QUERY CLOB (4000) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SQE_OWNER#
,      SQE_NAME
,      SQE_QUERY
FROM CTXSYS.DR$SQE;

Dependencies

[top of page]

CTXSYS.DR$SQE does not reference any database object

CTXSYS.DR$SQE is referenced by following:

SchemaAPPS
Package BodyICX_ITEM_DIAG_PVT - show dependent code
SchemaCTXSYS
ViewCTX_SQES
ViewCTX_USER_SQES
Package BodyDRILOAD - show dependent code
Package BodyDRIXMD - show dependent code