Modifying Elements of a Varray

The elements in a varray can be modified only as a whole.


CREATE TYPE t_varray AS VARRAY(3) OF VARCHAR2(50);
/

CREATE TABLE emp(
    id INTEGER PRIMARY KEY,
    first_name VARCHAR2(10),
    last_name VARCHAR2(10),
    addresses t_varray
);

SQL> UPDATE emp SET addresses = t_varray(
  2  'new value',
  3  'new value 2',
  4  'new value 3'
  5  )
  6  WHERE id = 1;

1 row updated.

SQL>
Home »
Oracle »
PL/SQL » 

Varrays:
  1. Creating a Varray Type
  2. Using a Varray Type to Define a Column
  3. Getting Information on a Varray
  4. Populating a Varray with Elements
  5. Retrieving Elements from a Varray
  6. Using TABLE() to Treat a VArrays
  7. Modifying Elements of a Varray
Related: