Re: pl/sql function
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 11 Aug 1999 13:44:08 -0400
Message-ID: <37B1B668.805EF2DC_at_Unforgettable.com>
Date: Wed, 11 Aug 1999 13:44:08 -0400
Message-ID: <37B1B668.805EF2DC_at_Unforgettable.com>
That doesn't tell whether the string is an integer. It just tells if it is a valid numeric value.
Erich Bauer wrote:
> Hi,
>
> you can just try to convert the string to an integer like
>
> begin
> your_numer := to_number ( your_string );
> string_is_number := true;
> exception
> when value_error then
> string_is_number := false;
> end;
>
> DooHee Kim~ schrieb:
>
> > Is there a function to check if a given string is iteger or not?
Received on Wed Aug 11 1999 - 19:44:08 CEST