Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Update the variable of object datatype?
You have to use the funny-looking THE. Like this:
update THE (select address from home where name='CCHANG') set address='Florida' where season='Winter';
C Chang <cschang_at_maxinter.net> wrote in message news:<3D51B0C8.89F_at_maxinter.net>...
> Our previous DB consultant left behind a table as
> Home ( name VARCHAR2(20),
> address Address_t );
>
> Address_t is an object type table which is composed with object type
> datatype- address_o as (season, address) so the table content look like
> as
> Home ( 'CCHANG', Address_t(address_o('SUMMER', 'Anchorage'), address_o(
> 'WINTER', 'Bahama')) );
>
> How do I update the SUMMER'address with such structure? I have tried
> several times with the dot(.) syntax, but never success. And I can't
> find a similar information in Oracle 8i ref book. Thanks for anyone's
> help
>
> Chisoon
Received on Thu Aug 08 2002 - 12:15:28 CDT