Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.29 DBA_SOURCE

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.29 DBA_SOURCE

The DBA_SOURCE view provides the source code listing of all objects in the database.

Name

Type

Description

owner

VARCHAR2

User name of the program’s owner.

schemaname

VARCHAR2

Name of the schema in which the program belongs.

name

VARCHAR2

Name of the program.

type

VARCHAR2

Type of program – possible values are: FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, and TRIGGER.

line

INTEGER

Source code line number relative to a given program.

text

VARCHAR2

Line of source code text.

Previous PageTable Of ContentsNext Page