updating collection Hi,
I have this structure
CREATE OR REPLACE TYPE Slot AS OBJECT (
Name VARCHAR2(255),
SlotValue VARCHAR2(2048)
);
CREATE OR REPLACE TYPE Slot_Array AS VARRAY(30) OF Slot;
CREATE OR REPLACE TYPE Ob AS OBJECT (
ID integer,
Slots Slot_Array
);
how can I update a slotvalue if I have ID using an update statement ?
Thanks
Fred |