Re: Function to check if something is number

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 15 Aug 2006 23:02:36 GMT
Message-ID: <gosEg.9492$9T3.5158@newssvr25.news.prodigy.net>

<alex.chenaki_at_gmail.com> wrote in message news:1155679483.249748.32770_at_74g2000cwt.googlegroups.com...
> Does there exist an IsNumeric(..) or similar function in PL/SQL? If so,
> what is it?
>
> Thanks!
> Alex
>

Something like below what you're looking for? FUNCTION isnumeric( p_string IN VARCHAR2 )

RETURN BOOLEAN IS

v_number NUMBER(38) := 0;

BEGIN v_number := to_number(p_string);

RETURN TRUE; EXCEPTION WHEN value_error THEN

RETURN FALSE; END isnumeric; Received on Tue Aug 15 2006 - 18:02:36 CDT