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

Home -> Community -> Usenet -> c.d.o.misc -> Re: INSTR

Re: INSTR

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Fri, 11 Jan 2002 15:06:47 -0000
Message-ID: <a1mv1m$b1d$1@sun-cc204.lut.ac.uk> 





How about something like:



SELECT translate('1my2string3', '0123456789', ' ') FROM dual



Andy



"Gonzalo" <gpina2k_at_hotmail.com> wrote in message
news:3c3ef705$1_at_dnewserver.firstcom.cl...


> I nedd fin into string any character <> to numeric,

> but instr only find one this at time.

>

>

Received on Fri Jan 11 2002 - 09:06:47 CST












Original text of this message













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