Piece-wise update on nested table?

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