Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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