I don't think sql loader is your tool here...

A simple update statement should work...

update table set name = name || ' -special' where empid in (...) +
additional criteria; ...

Try building a select statement first to get the criteria right and check
the format for the update.... Then convert it to an update statement


John Best - Project Manager (PMP)
Caterpillar Global IT
Distributed Factory & Procurement Systems Development
309-675-9950 (5-9950)
[Email address protected]



"laura" <oracledba-ezmlmshield-x13376707.[Email address protected]
09/30/2005 01:00 PM


To
To
"LazyDBA Discussion" <[Email address protected]
cc




Subject
append data to data already in a column




Caterpillar: Confidential Green Retain Until: 10/30/2005 Retention
Category: G90 - General Matters/Administration


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?



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page