Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.9 ALL_SOURCE

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.9 ALL_SOURCE

The ALL_SOURCE view provides a source code listing of the following program types – functions, procedures, triggers, package specifications, and package bodies.

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