Example: Creating Tables and Set Elements in 1-D Array - Teradata Vantage

Consider the following 1-D ARRAY data type:

CREATE TYPE phonenumbers_ary AS CHAR(10) ARRAY[5];

The following statement creates a table with a column named ephone with a data type of phonenumbers_ary.

CREATE TABLE my_table (eno INTEGER, ephone phonenumbers_ary);

The following statement uses an ARRAY element reference to set element 3 of the array to the value '5551234567'. If elements 1 and 2 in the array were not initialized, this UPDATE statement automatically sets those elements to null.

UPDATE my_table
SET ephone[3] = '5551234567';