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) INLINE	Object owner
NAME	VARCHAR2(30) INLINE	Object name
TYPE	VARCHAR2(12) INLINE 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