Updated on 2022-07-29 GMT+08:00

DBA_SOURCE

DBA_SOURCE displays all stored procedures or functions in the database, and it provides the columns defined by the stored procedures or functions. It is accessible only to users with system administrator rights.

Table 1 DBA_SOURCE columns

Name

Type

Description

owner

character varying(64)

Owner of the stored procedure or the function

name

character varying(64)

Name of the stored procedure or the function

text

text

Definition of the stored procedure or the function