ALL_SOURCE_AE

ALL_SOURCE_AE describes the text source of the stored objects (across all editions) accessible to the current user.

Related Views

  • DBA_SOURCE_AE describes the text source of all stored objects (across all editions) in the database.

  • USER_SOURCE_AE describes the text source of the stored objects (across all editions) owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the object
NAME VARCHAR2(30)   Name of the object
TYPE VARCHAR2(12)   Type of the object:

  • TYPE

  • TYPE BODY

  • PROCEDURE

  • FUNCTION

  • PACKAGE

  • PACKAGE BODY

  • LIBRARY

  • JAVA SOURCE
LINE NUMBER   Line number of this line of source
TEXT VARCHAR2(4000)   Source text
EDITION_NAME VARCHAR2(30)   Name of the Edition

See Also: