[Home] [Help] [Dependency Information]
Object Name: | JOB$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_JOB_JOB | NORMAL | UNIQUE | SYSTEM | JOB |
I_JOB_NEXT | NORMAL | NONUNIQUE | SYSTEM | NEXT_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB | NUMBER | Yes | ||
LOWNER | VARCHAR2 | (128) | Yes | |
POWNER | VARCHAR2 | (128) | Yes | |
COWNER | VARCHAR2 | (128) | Yes | |
LAST_DATE | DATE | |||
THIS_DATE | DATE | |||
NEXT_DATE | DATE | Yes | ||
TOTAL | NUMBER | Yes | ||
INTERVAL# | VARCHAR2 | (200) | Yes | |
FAILURES | NUMBER | |||
FLAG | NUMBER | Yes | ||
WHAT | VARCHAR2 | (4000) | ||
NLSENV | VARCHAR2 | (4000) | ||
ENV | RAW | (32) | ||
CUR_SES_LABEL | MLSLABEL | (4) | ||
CLEARANCE_HI | MLSLABEL | (4) | ||
CLEARANCE_LO | MLSLABEL | (4) | ||
CHARENV | VARCHAR2 | (4000) | ||
FIELD1 | NUMBER | |||
SCHEDULER_FLAGS | NUMBER | |||
XID | VARCHAR2 | (40) |
Cut, paste (and edit) the following text to query this object:
SELECT JOB
, LOWNER
, POWNER
, COWNER
, LAST_DATE
, THIS_DATE
, NEXT_DATE
, TOTAL
, INTERVAL#
, FAILURES
, FLAG
, WHAT
, NLSENV
, ENV
, CUR_SES_LABEL
, CLEARANCE_HI
, CLEARANCE_LO
, CHARENV
, FIELD1
, SCHEDULER_FLAGS
, XID
FROM SYS.JOB$;
SYS.JOB$ does not reference any database object
SYS.JOB$ is referenced by following:
|
|
|