SYS.ALL_SOURCE

The ALL_SOURCE view describes the text source of the stored objects accessible to the current user.

Related views

SYS.DBA_SOURCE describes the text source of all stored objects. It has the same columns as ALL_SOURCE.
SYS.USER_SOURCE describes the text source of the stored objects that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2 (30) NOT NULL	Object owner.
NAME	VARCHAR2 (30) NOT NULL	Object name.
TYPE	VARCHAR2 (12) NOT NULL	Object type (such as PROCEDURE, FUNCTION, PACKAGE).
LINE	TT_INTEGER NOT NULL	Line number of this line of source.
TEXT	VARCHAR2 (4000) NOT INLINE	Text source of the stored object.