Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Question? Numeric Functions
In the Feuerstein PL/SQL manual from Oreily there is a large section
describing his attempts to solve this same problem. I don't have it near by
but if you are doing SQL you should have it handy someplace
Ray Vonhollen <RVONHOLLEN_at_pacbell.net> wrote in message
news:3ADD028B.2B51A249_at_pacbell.net...
> Is there any good numeric function available that can check to see if a
> varchar2 or char column contains a pure numeric number? Preferably, a
> function that can be checked by an If Statement without generating a
> PLS-00382 error. It would only execute the preceding Block if statements
> and no execute upon failure.
>
> As an example a column containing the values '102-1' would generate an
> error in using the TO_NUMBER() function, but a column containing the
> values '102.1' would not.
>
> Any help would be greatly appreciated.
>
> Ray-
Received on Wed Apr 18 2001 - 12:16:28 CDT
![]() |
![]() |