These examples all create a one-dimensional ARRAY type named phonenumbers_ary.
The first example uses Teradata-style syntax and initializes all of its elements to nulls.
CREATE TYPE phonenumbers_ary AS CHARACTER(10) ARRAY[5] DEFAULT NULL;
The next example uses Oracle-style syntax to create an identical VARRAY type to the type created in the first example.
CREATE TYPE phonenumbers_ary AS VARRAY(5) OF CHARACTER(10) DEFAULT NULL;
The final example uses Oracle-style syntax to create an identical VARRAY type, but does not initialize the elements to nulls.
CREATE TYPE phonenumbers_ary AS VARRAY(5) OF CHARACTER(10);