Re: Update an Object Type Column

From: Arun Mathur <themathurs_at_gmail.com>
Date: Fri, 21 Dec 2007 10:02:27 -0800 (PST)
Message-ID: <40b0f1a7-899a-41d7-8ee0-5bbf7c14f4d9@l1g2000hsa.googlegroups.com>

On Dec 21, 12:25 pm, "jimmy.brock" <jimmybr..._at_gmail.com> wrote:
> I find the solution I was looking for, where I can update only the
> attributes I want without updating the other attributes.
>
> UPDATE t t_update
> SET
> t_update.ACKHEADER.MESSAGEDATE = sysdate
> , t_update.ACKHEADER.TRANSMISSIONACKCODE = '01'
> WHERE t_id = 1 ;

Thanks Jimmy Received on Fri Dec 21 2007 - 12:02:27 CST