Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> select only number from varchar2

select only number from varchar2

From: <rx_at_wo.cz>
Date: Sat, 4 Jan 2003 16:08:41 +0100
Message-ID: <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?
Received on Sat Jan 04 2003 - 09:08:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US