ALL_SOURCE v16

The ALL_SOURCE view provides a source code listing of the following program types: functions, procedures, triggers, package specifications, and package bodies.

NameTypeDescription
ownerTEXTUser name of the program owner.
schema_nameTEXTName of the schema in which the program belongs.
nameTEXTName of the program.
typeTEXTType of program. Possible values are: FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, and TRIGGER
lineINTEGERSource code line number relative to a given program.
textTEXTLine of source code text.