Connecting Tech Pros Worldwide Help | Site Map

changing column data

Newbie
 
Join Date: Jul 2007
Posts: 1
#1: Jul 17 '07
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's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,505
#2: Jul 17 '07

re: changing column data


please post your question clearly

and why can't you use update ?

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