Home » SQL & PL/SQL » SQL & PL/SQL » SU@RE#SH$ i want the output as SURESH (11g)
SU@RE#SH$ i want the output as SURESH [message #607556] Sun, 09 February 2014 12:52 Go to next message
ashwanth77
Messages: 95
Registered: April 2013
Location: India
Member
How to extract the output as SURESH from the input 'SU@RE#SH$'?

Report message to a moderator

Re: SU@RE#SH$ i want the output as SURESH [message #607557 is a reply to message #607556] Sun, 09 February 2014 12:57 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
You need to refine your question. For example (and I am only guessing):
"I need to process a string in order to remove all characters that are not upper case letters."
Once you define the problem precisely, solutions will become apparent. For example, you could test each character.

[Updated on: Sun, 09 February 2014 12:57]

Report message to a moderator

Re: SU@RE#SH$ i want the output as SURESH [message #607558 is a reply to message #607556] Sun, 09 February 2014 14:10 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at TRANSLATE function.

Report message to a moderator

Previous Topic: for loop
Next Topic: Boolean Data type usage in PL/SQl Block
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 07:38:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.