Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.33 DBA_TYPES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.33 DBA_TYPES

The DBA_TYPES view provides information about all object types in the database.

Name

Type

Description

Owner

TEXT

The owner of the object type.

schema_name

TEXT

The name of the schema in which the type is defined.

type_name

TEXT

The name of the type.

type_oid

OID

The object identifier (OID) of the type.

typecode

TEXT

The typecode of the type. Possible values are:

      OBJECT

      COLLECTION

      OTHER

attributes

INTEGER

The number of attributes in the type.

Previous PageTable Of ContentsNext Page