Purpose
USER_SOURCE displays the text sources of the stored objects of the current user. Its fields are the same as those of the ALL_SOURCE view, except that it does not have the OWNER field.
Related views
DBA_SOURCE
ALL_SOURCE
Fields
| Field | 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. |