[Home] [Help] [Dependency Information]
Object Name: | SCHEDULER$_NOTIFICATION |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SCHEDULER_NOTIFICATION1 | NORMAL | NONUNIQUE | SYSTEM |
OWNER
JOB_NAME JOB_SUBNAME |
I_SCHEDULER_NOTIFICATION2 | NORMAL | NONUNIQUE | SYSTEM |
OWNER
JOB_NAME JOB_SUBNAME EVENT_FLAG |
I_SCHEDULER_NOTIFICATION3 | NORMAL | NONUNIQUE | SYSTEM | OWNER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (128) | Yes | |
JOB_SUBNAME | VARCHAR2 | (128) | ||
OWNER | VARCHAR2 | (128) | Yes | |
RECIPIENT | VARCHAR2 | (4000) | Yes | |
SENDER | VARCHAR2 | (4000) | ||
SUBJECT | VARCHAR2 | (4000) | ||
BODY | VARCHAR2 | (4000) | ||
EVENT_FLAG | NUMBER | Yes | ||
FILTER_CONDITION | VARCHAR2 | (4000) | ||
FLAGS | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NAME
, JOB_SUBNAME
, OWNER
, RECIPIENT
, SENDER
, SUBJECT
, BODY
, EVENT_FLAG
, FILTER_CONDITION
, FLAGS
FROM SYS.SCHEDULER$_NOTIFICATION;
SYS.SCHEDULER$_NOTIFICATION does not reference any database object
SYS.SCHEDULER$_NOTIFICATION is referenced by following:
|
|
|