| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ALL_SCHEDULER_PROGRAM_ARGS displays information about the arguments of the Scheduler programs accessible to the current user.
DBA_SCHEDULER_PROGRAM_ARGS displays information about the arguments of all Scheduler programs in the database.
USER_SCHEDULER_PROGRAM_ARGS displays information about the arguments of the Scheduler programs owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
OWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the program to which the argument belongs | 
PROGRAM_NAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the program to which the argument belongs | 
ARGUMENT_NAME | 
VARCHAR2(30) | 
Optional name of the argument | |
ARGUMENT_POSITION | 
NUMBER | 
NOT NULL | 
Position of the argument in the argument list | 
ARGUMENT_TYPE | 
VARCHAR2(61) | 
Datatype of the argument | |
METADATA_ATTRIBUTE | 
VARCHAR2(19) | 
Metadata attribute:
  | 
|
DEFAULT_VALUE | 
VARCHAR2(4000) | 
Default value taken by the argument (in string format) if the argument is a string | |
DEFAULT_ANYDATA_VALUE | 
ANYDATA | 
Default value taken by the argument (in AnyData format) | |
OUT_ARGUMENT | 
VARCHAR2(5) | 
Reserved for future use |