Oracle教程 2023-02-23

Oracle 视图 ALL_SCHEDULER_PROGRAM_ARGS 官方解释，作用，如何使用详细说明

Oracle视图ALL_SCHEDULER_PROGRAM_ARGS用来查询位属性列表（ATTRIBUTE_LIST）定义的所有预定义程序参数的值。它以一系列的行根据其参数的名称显示所有参数的值。

使用方法：

以下示例查询ALL_SCHEDULER_PROGRAM_ARGS视图：

SQL>SELECT * FROM ALL_SCHEDULER_PROGRAM_ARGS;

这条SQL语句将以列的形式显示ALL_SCHEDULER_PROGRAM_ARGS视图中的所有程序参数值。

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(128)`	`NOT NULL`	Owner of the program to which the argument belongs
`PROGRAM_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the program to which the argument belongs
`ARGUMENT_NAME`	`VARCHAR2(128)`		Optional name of the argument
`ARGUMENT_POSITION`	`NUMBER`	`NOT NULL`	Position of the argument in the argument list
`ARGUMENT_TYPE`	`VARCHAR2(257)`		Data type of the argument
`METADATA_ATTRIBUTE`	`VARCHAR2(19)`		Metadata attribute: `JOB_NAME` `JOB_OWNER` `JOB_START` `WINDOW_START` `WINDOW_END` `JOB_SUBNAME` `EVENT_MESSAGE` `JOB_SCHEDULED_START`
`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