Purpose
This view displays information about all programs in the current tenant.
Applicability
This view is available starting with OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | YES | The owner of the program. |
| PROGRAM_NAME | VARCHAR2(30) | NO | The name of the program. |
| PROGRAM_TYPE | VARCHAR2(16) | YES | The type of the program. Valid values: PLSQL_BLOCKSTORED_PROCEDUREEXECUTABLE |
| PROGRAM_ACTION | VARCHAR2(4000) | YES | The string that specifies the operation of the program. |
| NUMBER_OF_ARGUMENTS | NUMBER(38) | YES | The number of parameters accepted by the program. |
Sample query
Query all program information in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_SCHEDULER_PROGRAM;
The query result is as follows:
+-------+--------------+------------------+----------------+---------------------+
| OWNER | PROGRAM_NAME | PROGRAM_TYPE | PROGRAM_ACTION | NUMBER_OF_ARGUMENTS |
+-------+--------------+------------------+----------------+---------------------+
| SYS | empprogram | STORED_PROCEDURE | hr.empprogram | 0 |
+-------+--------------+------------------+----------------+---------------------+
1 row in set