DBA_SOURCE

2024-03-05 01:54:26  Updated

Purpose

The DBA_SOURCE view displays the text sources of all stored objects in the database. Its columns are the same as those of ALL_SOURCE.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

  • ALL_SOURCE

  • USER_SOURCE

Columns

Column Type Nullable? Description
OWNER VARCHAR2(30) NO The owner of the object.
NAME VARCHAR2(30) 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 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.

Contact Us