I don't know if you can use SQL Loader for this. I might just try an
update statement.

-----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