Re: Update the variable of object datatype?

C Chang wrote:

> 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

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/09_objs.htm#4670

Daniel Morgan Received on Thu Aug 08 2002 - 11:01:11 CDT