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

VIEW: SYS.CDB_SCHEDULER_PROGRAM_ARGS

Object Details
Object Name: CDB_SCHEDULER_PROGRAM_ARGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All arguments of all scheduler programs in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the program this argument belongs to
PROGRAM_NAME VARCHAR2 (30) Yes Name of the program this argument belongs to
ARGUMENT_NAME VARCHAR2 (128)
Optional name of this argument
ARGUMENT_POSITION NUMBER
Yes Position of this argument in the argument list
ARGUMENT_TYPE VARCHAR2 (61)
Data type of this argument
METADATA_ATTRIBUTE VARCHAR2 (19)
Metadata attribute (if a metadata argument)
DEFAULT_VALUE VARCHAR2 (4000)
Default value taken by this argument in string format (if a string)
DEFAULT_ANYDATA_VALUE ANYDATA (4408)
Default value taken by this argument in AnyData format
OUT_ARGUMENT VARCHAR2 (5)
Whether this is an out argument
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      PROGRAM_NAME
,      ARGUMENT_NAME
,      ARGUMENT_POSITION
,      ARGUMENT_TYPE
,      METADATA_ATTRIBUTE
,      DEFAULT_VALUE
,      DEFAULT_ANYDATA_VALUE
,      OUT_ARGUMENT
,      CON_ID
FROM SYS.CDB_SCHEDULER_PROGRAM_ARGS;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_PROGRAM_ARGS references the following:

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

SchemaPUBLIC
SynonymCDB_SCHEDULER_PROGRAM_ARGS