Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Piece-wise update on nested table?

Piece-wise update on nested table?

From: <prince_kumar_at_my-deja.com>
Date: 2000/08/01
Message-ID: <8m564s$q07$1@nnrp1.deja.com>#1/1

Hi:

Can I update each element of a nested table?

I have a table like the following one:

Table:

User_Balance

( user_id varchar2(15) primary key,

         user_pts user_pts_ntab,         -- nested table
         fld1      ...
         fld2      ....)

user_pts_ntab has the following structure

(id number(10),
points number(15,0) )

user_id user_pts.id user_pts.points etc...

------- ------------ ---------------- ---
pkumar  10           125
        20           200

vkumar  10           100
        30           50
        40           180

Now, how do I update the points from 125 to 125 + 125 * 0.5 where the user_id = 'pkumar' and user_pts.id = 10 ;

regards,

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US