OraFAQ Forum: SQL & PL/SQL » Extract numbers from a string

Home » SQL & PL/SQL » SQL & PL/SQL » Extract numbers from a string

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

Extract numbers from a string [message #20705]

Fri, 14 June 2002 11:59

lalitha
Messages: 39
Registered: June 2002

Member

Hi,

Can i extract the numbers from a string through sql query? For eg, if i give the value as 'a2c4e6' - i should get only 246. I can write a pl/sql procedure for doing the same, but i want to know if it could be done through queries.

regards

Lalitha

Report message to a moderator

Re: Extract numbers from a string [message #20707 is a reply to message #20705]

Fri, 14 June 2002 12:47

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

This may have been what you meant by writing a PL/SQL procedure, but you could write a function that takes a string and returns the numbers only - and then call that function from a query.

Report message to a moderator

Previous Topic:	Passing Data between Procedures
Next Topic:	Converting SQL to PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 16:44:05 CDT 2024