Purpose
The USER_SOURCE view displays the text sources of the stored objects of the current user. Its columns are the same as those of the ALL_SOURCE view, except that it does not have the OWNER column.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_SOURCE
ALL_SOURCE
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| NAME | VARCHAR2(30) | NO | The name of the object. |
| TYPE | VARCHAR2(12) | NO | Object type |
| LINE | NUMBER | NO | The number of the line corresponding to the TEXT column in the source code. |
| TEXT | CLOB | NO | The source code of the current line. |
| ORIGIN_CON_ID | NUMBER(38) | NO | At present, this column is not supported and is NULL by default. |