how to call update query in procedure of oracle
- by Deven
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);