Re: updating collection

Frederic Houbie wrote:

> 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

You can find examples at: http://www.psoug.org/reference/type.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)