Updates all or a subset of the elements in array_expr to the specified new value.
ARRAY_UPDATE returns a new copy of the array specified by array_expr with the specified elements updated to the new value.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.