Thank you but I am talking about sqlplus !
Kenneth C Stahl <BlueSax_at_Unforgettable.com> a écrit dans le message :
384E5E95.79FB2E6C_at_Unforgettable.com...
> Olivier BRUZEAUX wrote:
> >
> > I am looking for an sql command to test in my string is only numeric ??
> > VARCHAR string [15]
> >
> > Olivier
>
> If you are talking about plsql, then do it like this:
>
> Function Is_Number(Buff varchar2) return integer is
> Dummy Number := 0;
> begin
> Dummy := Buff;
> return(0);
> exception
> when invalid_number then
> return(1);
> when others then
> return(2)
> end;
>
> If you pass a numeric string to the function it will return 0 if the value
> was truely numeric, if it is an invalid number it will return 1. If there
> was some other error it will return 2.
Received on Wed Dec 08 1999 - 07:40:43 CST
