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 -> Re: test a column value

Re: test a column value

From: ji <ji_at_hass.com.au>
Date: Tue, 29 Oct 2002 09:06:03 +1100
Message-ID: <3tiv9.472$S5.26455@nasal.pacific.net.au>


Hi

I guess I didn't make my question clear:

I don't want to match particular characters or number, but to detect the column is containing characters or number.

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DBD6890.CD7A60EC_at_exesolutions.com...
> ji wrote:
>
> > Hi:
> >
> > How can I test a column (datatype varchar2) value in Oracle 8.1.7, I
need to
> > find out this column contains a string of numbers (1,2,3...) or
characters
> > (a,b,c ...) in any position.
> >
> > much appreciate
>
> Use the INSTR function.
>
> Daniel Morgan
>
Received on Mon Oct 28 2002 - 16:06:03 CST

Original text of this message

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