The DBA_SOURCE view provides a list of source code for all objects in the database.

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.