select only number from varchar2
This is a discussion on select only number from varchar2 within the Oracle Database forums, part of the Database Server Software category; --> for example I have this records in varchar2 column: A123D BLA124XX 125 lkl567836785366AW 2Q and now I need select ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-22-2008, 05:26 PM
| ||||
| ||||
 Re: select only number from varchar2 <rx@wo.cz> wrote in message news:<av6tdv$clm6a$1@ID-123390.news.dfncis.de>... > for example I have this records in varchar2 column: > > A123D > BLA124XX > 125 > lkl567836785366AW > 2Q > > and now I need select only number for spool : > > 123 > 124 > 125 > 567836785366 > 2 > > > Have you any idea? Look up usage of TRANSLATE(char, from, to). Here is a quick short example, SQL> SELECT TRANSLATE('AB123CD', '123ABCD', '123') FROM DUAL; TRA --- 123 /Rauf Sarwar      |
Linear Mode
