Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_SOURCE

Current source on stored objects that user is allowed to create

Columns
   ___________________________
 
   TYPE
      Type of the object: `TYPE`, `TYPE BODY`, `PROCEDURE`, `FUNCTION`, `PACKAGE`, `PACKAGE BODY` or `JAVA SOURCE`
   OWNER
      Owner of the object
   LINE
      Line number of this line of source
   NAME
      Name of the object
   TEXT
      Source text

Related Commands:

 DBA_ERRORS         ALL_ERRORS           USER_ERRORS          ERROR_SIZE 
 DBA_LIBRARIES      ALL_LIBRARIES        USER_LIBRARIES 
 DBA_OBJECT_SIZE    USER_OBJECT_SIZE



Back to the Top

Simon Sheppard
SS64.com