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_ARGSdisplays information about the arguments of all Scheduler programs in the database.USER_SCHEDULER_PROGRAM_ARGSdisplays information about the arguments of the Scheduler programs owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Owner of the program to which the argument belongs |
|
|
| Name of the program to which the argument belongs |
|
| Optional name of the argument | |
|
|
| Position of the argument in the argument list |
|
| Data type of the argument | |
|
| Metadata attribute:
| |
|
| Default value taken by the argument (in string format) if the argument is a string | |
|
| Default value taken by the argument (in AnyData format) | |
|
| Reserved for future use |
See Also:
“DBA_SCHEDULER_PROGRAM_ARGS”
“USER_SCHEDULER_PROGRAM_ARGS”
想用智盟CMS 为企业建一个能获客的官网?扫码咨询。