PL/SQL   «Prev 

Updating within varray syntax

Syntax for updating Varray 
UPDATE <table_name>
SET <varray_name> = <variable>
WHERE <clause>;
Syntax for updating Varray

Location 1 The UPDATE statement with the table name
Location 2 The SET clause to update the value within a varray
Location 3 The WHERE clause to select a particular row of the object table