OraFAQ Forum: SQL & PL/SQL » Urgent help in Extracting numbers only

Home » SQL & PL/SQL » SQL & PL/SQL » Urgent help in Extracting numbers only (Oracle10g)

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

Urgent help in Extracting numbers only [message #384316]

Tue, 03 February 2009 04:41

sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai

Member

My Query is like this,

SELECT INSTLNUM,replace(INSTLNUM,'Installments ')INSTLAMT,COMP_APPL_ID id ,APPLID
FROM TABLE(CAST(FNGETFORMATTEDINSTALLMENTS(145) AS TABINSTALLPLOTNEW))

I have to extract only numbers from first column.
How to extract it ??Please help me??

Ex. 1 -59 Installments -->i need only 1 and 59 seperated values.
60th Installment --->Only 60
Is regular_expression is useful?/