Home » SQL & PL/SQL » SQL & PL/SQL » Any simple way to achieve this
Any simple way to achieve this [message #349077] Thu, 18 September 2008 16:08 Go to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
I have a string as follows:

REM_WLBX_JB_IMPORT_80050


I need to get the output as

REMWLBXJBIMPORT80050

i.e. eveything combined without any underscores. Please let me know the simplest and most efficient way to do this.
Re: Any simple way to achieve this [message #349078 is a reply to message #349077] Thu, 18 September 2008 16:11 Go to previous message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
Got the answer. It can be done using REPLACE

Sorry for bothering
Previous Topic: displaying create trigger details
Next Topic: XML parsing function
Goto Forum:
  


Current Time: Thu Dec 08 20:00:59 CST 2016

Total time taken to generate the page: 0.09994 seconds