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

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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)