changing column data

[shaan11984]

hi ,

I have to write a stored procedure in pl/sql to change data in the column of a table.I cannot use update as I have 16000 rows .
the foloowing is an example of the change
item_name
abc
dfdgf
adasf
adasf ...
the column has to b changed to
Part 1
Part 2
Part 3 ..
Any idea how to implement the code

[debasisdas]

please post your question clearly

and why can't you use update ?

....only because it contains 16000 records ...???