Overview
USER_SOURCE describes the source code of procedures and functions accessible to the current user.
Related views
DBA_SOURCE
ALL_SOURCE
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| 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. |