Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

append data to data already in a column

Ratzie
Super Advisor

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?
1 REPLY
Ratzie
Super Advisor

Re: append data to data already in a column

Sorry guys figured it out after I sent this.

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