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: 64103
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: DBMS_CRYPTO
Next Topic: How to find procedure or package
Goto Forum:
  


Current Time: Sun Dec 04 12:55:25 CST 2016

Total time taken to generate the page: 0.29610 seconds