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


TABLE: SYS.SCHEDULER$_PROGRAM_ARGUMENT

Object Details
Object Name: SCHEDULER$_PROGRAM_ARGUMENT
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SCHEDULER$_PROGRAM_ARG_PK
  1. ColumnOID
  2. ColumnPOSITION
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_PROGRAM_ARG_PK NORMAL UNIQUE TablespaceSYSTEM ColumnOID
ColumnPOSITION
SYS_IL0000364218C00006$$ LOB UNIQUE TablespaceSYSTEM
I_SCHEDULER_PROGRAM_ARGUMENT1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnOID
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
OID NUMBER
Yes
NAME VARCHAR2 (128)
POSITION NUMBER
Yes
TYPE_NUMBER NUMBER

USER_TYPE_NUM NUMBER

VALUE ANYDATA (3748)
FLAGS NUMBER

Query Text

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


SELECT OID
,      NAME
,      POSITION
,      TYPE_NUMBER
,      USER_TYPE_NUM
,      VALUE
,      FLAGS
FROM SYS.SCHEDULER$_PROGRAM_ARGUMENT;

Dependencies

[top of page]

SYS.SCHEDULER$_PROGRAM_ARGUMENT references the following:

SchemaSYS
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code
SYS.SCHEDULER$_PROGRAM_ARGUMENT is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_JOB_ARGS
ViewALL_SCHEDULER_PROGRAM_ARGS
ViewDBA_SCHEDULER_JOB_ARGS
ViewDBA_SCHEDULER_PROGRAM_ARGS
Package BodyDBMS_SCHED_MAIN_EXPORT - show dependent code
ViewUSER_SCHEDULER_JOB_ARGS
ViewUSER_SCHEDULER_PROGRAM_ARGS