Table of Contents Previous Next


8 Advanced JDBC Connector Functionality : 8.6 Using Object Types and Collections with Java

The SQL CREATE TYPE command is used to create a user-defined object type, which is stored in the Advanced Server database. The CREATE TYPE command is also used to create a collection, commonly referred to as an array, which is also stored in the Advanced Server database.
The basic object type is created with the CREATE TYPE AS OBJECT command along with optional usage of the CREATE TYPE BODY command.
A nested table type collection is created using the CREATE TYPE AS TABLE OF command. A varray type collection is created with the CREATE TYPE VARRAY command.

8 Advanced JDBC Connector Functionality : 8.6 Using Object Types and Collections with Java

Table of Contents Previous Next