oracle - Update huge data in database -

i have done little googling still abstract if update table in database;in scenrio shall use store procedure.if yes,then how gain performance in code?

edit:

what trying do?

i supposed update around 2000+ or 3000+ {may vary in approx range} in table.

what have tried?

i had written simple update query :

update table set ... ... 

my senior asked me use instead stored procedure better way same.and trying figure out how?

first of all, stored procedures have nothing java. stored procedures gain performance because mean less communication between server , client needed complex tasks. whether or not use them depends on trying do. if can formulate task in 1 sql query, answer probably: no, won't performance gains - explained before, performance gains there if need make multiple queries in succession.

so, you:

• update 2000+ items 1 simple query -> no stored procedure necessary

• update 2000+ items 2000+ queries in loop -> yes, use stored procedure if means need call once 2000+ items

ok, else answer question how can create stored procedure java :-p