Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.45 USER_SOURCE

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.45 USER_SOURCE

The USER_SOURCE view provides information about all programs owned by the current user.

Name

Type

Description

schema_name

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