Home » SQL & PL/SQL » SQL & PL/SQL » Picking numbers from a character value
Picking numbers from a character value [message #204970] Wed, 22 November 2006 23:42 Go to next message
katejinu
Messages: 7
Registered: May 2006
Junior Member
Could anybody tell me how to pick up numbers fron a charater value? For Eg: I need to get 234 from 'qew234rr'

Thanks
Re: Picking numbers from a character value [message #204972 is a reply to message #204970] Wed, 22 November 2006 23:45 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi Kate,

Go through below link
http://www.orafaq.com/forum/t/72796/93410/



hope this helps
Taj
Re: Picking numbers from a character value [message #204984 is a reply to message #204972] Thu, 23 November 2006 00:13 Go to previous messageGo to next message
katejinu
Messages: 7
Registered: May 2006
Junior Member
Taj!!!!

Thanks a Million...Smile

Kate

Re: Picking numbers from a character value [message #204985 is a reply to message #204984] Thu, 23 November 2006 00:13 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member



You're Welcome !!!
Previous Topic: parent child relationship?
Next Topic: How to execute unicode format SQL script
Goto Forum:
  


Current Time: Fri Dec 02 13:52:57 CST 2016

Total time taken to generate the page: 0.05609 seconds