Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: jusungyang@yahoo.com (Jusung Yang)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Update the variable of object datatype?
Date: 8 Aug 2002 10:15:28 -0700
Organization: http://groups.google.com/
Lines: 23
Message-ID: <42ffa8fa.0208080915.20eaa58e@posting.google.com>
References: <3D51B0C8.89F@maxinter.net>
NNTP-Posting-Host: 64.168.22.105
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028826928 6939 127.0.0.1 (8 Aug 2002 17:15:28 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 17:15:28 GMT
Xref: easynews comp.databases.oracle.misc:85324
X-Received-Date: Thu, 08 Aug 2002 10:12:33 MST (news.easynews.com)

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@maxinter.net> wrote in message news:<3D51B0C8.89F@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