Home » SQL & PL/SQL » SQL & PL/SQL » Updating a field in a table
Updating a field in a table [message #18727] Tue, 12 February 2002 10:38 Go to next message
Naveen
Messages: 75
Registered: June 2001
Member
I am trying to append more information to a value that exists in a table for a field.

example: lets say in the Employee table of scott tiger...I want to make 'SMITH' as 'SMITH SR.' how can I do that? is there a function that I can use to append data to an already existing value.

Please do let me know.

Thank you

Report message to a moderator

Re: Updating a field in a table [message #18728 is a reply to message #18727] Tue, 12 February 2002 11:21 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
update emp
set ename=ename||' SR'
where empno=1234;

or

update emp
set ename=concat(ename,' SR')
where empno=1234;

Report message to a moderator

Re: Updating a field in a table [message #19158 is a reply to message #18727] Sun, 03 March 2002 23:24 Go to previous message
jeya
Messages: 18
Registered: January 2001
Junior Member
update employee set name=name||' sr' where no=1234;

Report message to a moderator

Previous Topic: finding the names where the 3rd letter is an A
Next Topic: varchars in functions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 11:14:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.