Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: test a column value
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