HI
I want remove float number from string
I have tried below code.
select (2.73 lb. ,'[[:alpha:]]|_') from dual;
but for above query, i got o/p :
2.73 .
but I need to get number and decimal point not other points
Sample o/p
2.73
Edited by: 925896 on Feb 15, 2013 2:29 AM