Answer:

Cutdown to 2 statements
update ms1_tab
set val1 = decode(ls_id, 3, 40, 4, 50, 5, 60) -- or (ls_id + 1) * 10
where pd_id = 1 and mth_id = 2 and ls_id between 2 and 4;

update ms1_tab set val1 = 70 where pd_id = 1 and mth_id = 3 and ls_id =1;
 

Hth,

Sybrand Bakker, Oracle DBA
 
 

Question:

> Hi all
>
>     I want to fire a batch query with respect to update clause from OCI
> coz i would be having around 20K update clauses like
> update ms1_tab set val1 = 40 where pd_id = 1 and mth_id = 2 and ls_id =3
>
> update ms1_tab set val1 = 50 where pd_id = 1 and mth_id = 2 and ls_id =4
>
> update ms1_tab set val1 = 60 where pd_id = 1 and mth_id = 2 and ls_id =5
>
> update ms1_tab set val1 = 70 where pd_id = 1 and mth_id = 3 and ls_id =1
>
>
>
> and firing each of them independently would be pretty expensive
> so can i fire them to the Server in one go ??? (may be by putting the
> variable part i.e the where clause values in some text file .....just a
> guess)
>
>
> Thanks in advance
>
> Regards
> ~Parvinder
>