Feature
ALL_SOURCE displays the text sources of the stored objects accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_SOURCE
USER_SOURCE
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(30) | NO | The owner of the object. |
| NAME | VARCHAR2(30) | NO | Object name |
| TYPE | VARCHAR2(12) | NO | Object Type |
| 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. |