Home » SQL & PL/SQL » SQL & PL/SQL » update (oracle 9i)
update [message #413985] Mon, 20 July 2009 01:03 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
HOw can i update the first letter of ename 'R'with 'T'
ename
Ramesh
Raj
Mahesh
Ram

I want to update the ename like

Tamesh
Taj
Mahesh
Tam
Re: update [message #413987 is a reply to message #413985] Mon, 20 July 2009 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using UPDATE and REPLACE/SUBSTR or REPEXP_REPLACE.

Regards
Michel
Re: update [message #414008 is a reply to message #413985] Mon, 20 July 2009 02:10 Go to previous message
ds285269
Messages: 10
Registered: June 2009
Location: Mumbai
Junior Member
Hi ramesh,
We solve this issue by using DECODE function also, better to check it once...
Previous Topic: How to find procedure or package
Next Topic: how to replace string against some key_value table?
Goto Forum:
  


Current Time: Sat Aug 19 17:40:50 CDT 2017

Total time taken to generate the page: 0.01310 seconds