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