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