Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: updating collection

Re: updating collection

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 30 Apr 2004 20:35:26 -0700
Message-ID: <1083382521.841992@yasure>


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)
Received on Fri Apr 30 2004 - 22:35:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US