DBA_SOURCE

2023-08-18 09:26:34  Updated

Overview

DBA_SOURCE describes the source code of available procedures and functions in the database.

  • ALL_SOURCE

  • USER_SOURCE

Field description

Field name Type Nullable Description
OWNER VARCHAR2(128) NO The owner of the object.
NAME VARCHAR2(128) NO The name of the object.
TYPE VARCHAR2(12) NO The type of the object.
LINE NUMBER NO The number of the line corresponding to the TEXT field in the source code.
TEXT CLOB NO The source code of the current line.
ORIGIN_CON_ID NUMBER(38) NO At present, this field is not supported and is NULL by default.

Contact Us