In oracle, I need to add " -special " to the end of certain records in a
specific column in a table.

Table emp
emp # name address
123 frank 123 anywhere
122 susan 144 baywater
121 billy 146 anywhere
125 laurie 144 street
etc
table is huge...

Now I have a list of emp #'s that need the name appended with special.

So it should look like:
122 susan -special 144 baywater

I guess I would need to use sql loader?
How would I set it up?


Oracle LazyDBA home page