Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 8.1 Object Type Components

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

8.1 Object Type Components

Object types are created and stored in the database by using the following two constructs of the SPL language:

    ● The object type specification - This is the public interface specifying the attributes and method signatures of the object type.

    ● The object type body - This contains the implementation of the methods specified in the object type specification.

Note: Only the object type specification and attributes are supported at this time.

8.1.1 Object Type Specification Syntax

The following is the syntax of the object type specification:

CREATE [ OR REPLACE ] TYPE name { IS | AS } OBJECT
  ({ attribute { datatype | objtype | collecttype } }
   [, ...])

name is an identifier assigned to the object type. attribute is an identifier assigned to an attribute of the object type. datatype is a base data type. objtype is a previously defined object type. collecttype is a previously defined collection type.

Previous PageTable Of ContentsNext Page