Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.7 ALL_OBJECTS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.7 ALL_OBJECTS

The ALL_OBJECTS view provides information on the following database objects – tables, indexes, sequences, views, triggers, functions, procedures, packages, and package bodies. Note that only SPL triggers, functions, procedures, packages, and package bodies are shown – PL/pgSQL triggers and functions do not appear in the ALL_OBJECTS view.

Name

Type

Description

owner

VARCHAR2

User name of the object’s owner.

schemaname

VARCHAR2

Name of the schema in which the object belongs.

object_name

VARCHAR2

Name of the object.

object_type

VARCHAR2

Type of the object – possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW.

status

VARCHAR2

Whether or not the state of the object is valid. Currently, Included for compatibility only; always set to VALID.

Previous PageTable Of ContentsNext Page