[Home] [Help] [Dependency Information]
Object Name: | ALL_PROCEDURES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Functions/procedures/packages/types/triggers available to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
OBJECT_NAME | VARCHAR2 | (128) | Name of the object: top level function/procedure/package/type/trigger name | |
PROCEDURE_NAME | VARCHAR2 | (128) | Name of the package or type subprogram | |
OBJECT_ID | NUMBER | Object number of the object | ||
SUBPROGRAM_ID | NUMBER | Unique sub-program identifier | ||
OVERLOAD | VARCHAR2 | (40) | Overload unique identifier | |
OBJECT_TYPE | VARCHAR2 | (13) | The typename of the object | |
AGGREGATE | VARCHAR2 | (3) | Is it an aggregate function ? | |
PIPELINED | VARCHAR2 | (3) | Is it a pipelined table function ? | |
IMPLTYPEOWNER | VARCHAR2 | (128) | Name of the owner of the implementation type (if any) | |
IMPLTYPENAME | VARCHAR2 | (128) | Name of the implementation type (if any) | |
PARALLEL | VARCHAR2 | (3) | Is the procedure parallel enabled ? | |
INTERFACE | VARCHAR2 | (3) | ||
DETERMINISTIC | VARCHAR2 | (3) | ||
AUTHID | VARCHAR2 | (12) | ||
ORIGIN_CON_ID | NUMBER | ID of Container where row originates |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_NAME
, PROCEDURE_NAME
, OBJECT_ID
, SUBPROGRAM_ID
, OVERLOAD
, OBJECT_TYPE
, AGGREGATE
, PIPELINED
, IMPLTYPEOWNER
, IMPLTYPENAME
, PARALLEL
, INTERFACE
, DETERMINISTIC
, AUTHID
, ORIGIN_CON_ID
FROM SYS.ALL_PROCEDURES;
|
|
|