I'm not sure where SQL*Loader would come in to play... If you have all
the data in the emp table already, just do

UPDATE emp
SET name = name || ' -special
WHERE empno IN (list of emp #'s you have)

If you have a file of employee #'s that you want to update, you could
use SQL*Loader to load those into a new table with 1 column and do

UPDATE emp
SET name = name || ' -special
WHERE empno IN (SELECT empno
FROM <<your new table>>)

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: laura
[mailto:oracledba-ezmlmshield-x13376707.[Email address protected]
Sent: Friday, September 30, 2005 2:01 PM
To: LazyDBA Discussion
Subject: append data to data already in a column

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