how to call update query in procedure of oracle

Posted by Deven on Stack Overflow See other posts from Stack Overflow or by Deven
Published on 2010-04-08T06:37:05Z Indexed on 2010/04/08 6:43 UTC
Read the original article Hit count: 264

Filed under:

how to call update query in procedure of oracle

hello friends i am having one table t1 in which i am having userid, week and year fields r there if i want to call procedure which takes all three values as arguments and fire update query how can i do it

my update query should be like update t1 set week = (value of procedure argument) , year = (value of procedure argument) where userid=(value of procedure argument);

© Stack Overflow or respective owner

Related posts about Oracle