Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.43 USER_OBJECTS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.43 USER_OBJECTS

The USER_OBJECTS view provides information about all objects that are owned by the current user.

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

Included for compatibility only; always set to VALID.

Previous PageTable Of ContentsNext Page