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: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Mon, 28 Oct 2002 16:29:02 -0700
Message-ID: <3DBDC83E.CEBA6A7A@noaa.gov>


Same answer - Use the INSTR function.

But I'd recommend using this built-in Oracle function inside of your own custom written function so that the query is a lot cleaner.

TG

ji wrote:

> 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 - 17:29:02 CST

Original text of this message

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