17.05 - Example: Three-Dimensional ARRAY and VARRAY Types With a Negative Lower Bound on a Dimension - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following example creates a 3-dimensional ARRAY type that has a negative lower bound value for its third dimension.

The following example uses Teradata-style syntax.

     CREATE TYPE seismic_cube_4 AS
     measures_udt ARRAY [5][7][-10:10];

The following example uses Oracle-style syntax to define an equivalent seismic_cube_4 type, seismic_cube_5.

     CREATE TYPE seismic_cube_5 AS
     VARRAY (5)(7)(-10:10) OF measures_udt;