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. |