Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
ALL_SCHEDULER_PROGRAM_ARGS
displays information about the arguments of the Scheduler programs accessible to the current user.
Related Views
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(12) |
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 |