ISNUMERIC - CODE FOR THOSE WHO NEED IT [message #38368] |
Mon, 15 April 2002 14:08 |
KAW
Messages: 8 Registered: February 2001
|
Junior Member |
|
|
FUNCTION IsNumeric(P_Value IN VARCHAR2)
Return Boolean
IS
V_Numeric_Value NUMBER;
Begin
SELECT To_Number(P_Value) INTO V_Numeric_Value FROM Dual;
RETURN TRUE;
EXCEPTION
WHEN Invalid_Number THEN
Return FALSE;
End IsNumeric; -- End IsNumeric
|
|
|
|
Re: ISNUMERIC - Be careful, though! [message #38383 is a reply to message #38368] |
Tue, 16 April 2002 04:45 |
Jon
Messages: 483 Registered: May 2001
|
Senior Member |
|
|
Just don't confuse "numeric" with "all numbers". So if you wanted to test an SSN, for example, you could pass "2.096E-11" into this function and you would return TRUE. Nine positions and numeric...must be a valid SSN, right? Not!
|
|
|