Update an Object Type Column

From: jimmy.brock <jimmybrock_at_gmail.com>
Date: Fri, 21 Dec 2007 06:33:57 -0800 (PST)
Message-ID: <a18664dd-05ff-40eb-b4ea-95db7bfc79e3@j20g2000hsi.googlegroups.com>

I know how to update all values in an object type column, but how do you update only certain values?
I can't create a nested table or any other object because this database belongs to a vendor.

Here is what I have:

CREATE OR REPLACE TYPE ACKHEADER_TY

     AS OBJECT(
  MESSAGETYPE          		VARCHAR2(16)


, MESSAGENUMB          		VARCHAR2(100)

, MESSAGESENDERIDENTIFIER 	VARCHAR2(60)

, MESSAGERECEIVERIDENTIFIER 	VARCHAR2(60)

, MESSAGEDATE 			DATE

, TRANSMISSIONACKCODE      	VARCHAR2(2)

             )

/

CREATE TABLE t
(

  , t_id		NUMBER
  , agency_id	NUMBER(22)
  , ackheader	ackheader_ty
  , CONSTRAINT t_pk PRIMARY KEY (t_id)

)
/

INSERT INTO t
VALUES ( t_seq.nextval, 17,
ACKHEADER_TY('2','1001','FDA','PG',null,null)) /

I need to update ONLY the 'messagedate' and 'transmissionackcode' without changing the other values.

Thanks! Received on Fri Dec 21 2007 - 08:33:57 CST