Re: SQL Function

Thanks Daniel for that info.

I was really looking to avoid doing this in a PL/SQL block. What do you think about using

if mod(number, number) = 0 then it is a number?

Thanks
Prasad

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CCD7138.5FEF4BF5_at_exesolutions.com...
> Prasad Yarlagadda wrote:
>
> > Is there any standard SQL function available to check whether an array
of
> > characters is a String or a Number? I am looking for something like
> > IS_NUMBER or IS_CHARACTER. I don't want to write a function for it if
oracle
> > has already provided.
> >
> > TIA,
> > Prasad
>
> No. This must be done in a PL/SQL block such as the following:
>
> BEGIN
> test := TO_NUMBER(somevalue);
> <do something>
> EXCEPTION
> WHEN OTHERS THEN
> <do something else>
> END;
>
> If you don't do it this way you need to be very careful about what you
decide is
> a number. For example ... is 8.1.7.3 a number? It would be with a lot of
code
> I've seen written.
>
> Daniel Morgan
>
Received on Mon Apr 29 2002 - 11:36:41 CDT