The ALL_SOURCE view provides a source code list of the following program types: functions, procedures, triggers, package specifications, and package bodies.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the program belongs. |
schema_name | TEXT | The name of the schema to which the program belongs. |
name | TEXT | The name of the program. |
type | TEXT | The type of the program. Valid values: FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, and TRIGGER. |
line | INTEGER | The line number of the source code in a specified program. |
text | TEXT | The line of the source code text. |