OraFAQ Forum: SQL & PL/SQL » Need to get only characters from the given string

Home » SQL & PL/SQL » SQL & PL/SQL » Need to get only characters from the given string

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to get only characters from the given string [message #611523]

Thu, 03 April 2014 05:38

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi All ,

I need to get only the characters from the alpha numeric string by using regular expression

I am using the following query, but its not working .

Please help me

select regexp_substr('reva(12)', '[^a-z]')  val from dual

out put should be : reva

Thanks
Sai Pradyumn

Report message to a moderator

Re: Need to get only characters from the given string [message #611525 is a reply to message #611523]

Thu, 03 April 2014 06:06

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

'[[:alpha:]]+'

[Updated on: Thu, 03 April 2014 06:07]

Report message to a moderator

Re: Need to get only characters from the given string [message #611527 is a reply to message #611525]

Thu, 03 April 2014 06:15

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Thanks

its working fine

Report message to a moderator

Previous Topic:	before insert & instead OF INSERT trigger
Next Topic:	Dates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 16:13:51 CDT 2024