Re: Numeric string ??

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 8 Dec 1999 15:14:50 +0100
Message-ID: <82lovu$10vab$1@oceanite.cybercable.fr>

Try this function:

v734> Create or replace function IsNumber (Buff varchar2) Return integer is   2 Val Number;
  3 Begin

  4     Val := To_Number(Buff);
  5     Return(1);
  6  Exception
  7      When invalid_number then
  8         Return(0);
  9      When others then
 10         dbms_output.put_line(sqlerrm(sqlcode));
 11         Return(0);

 12 End;
 13 /

Function created.

v734> select isnumber('1') from dual;

ISNUMBER('1')

---

            1

1 row selected.

v734> select isnumber('a') from dual;

ISNUMBER('A')

---

            0

1 row selected.

--
Have a nice day
Michel

Olivier BRUZEAUX <obruzeau_at_telecom.capgemini.fr> a écrit dans le message : 82lek7$j2v$1_at_minus.oleane.net...
>
>
> I am looking for an sql command to test in my string is only numeric ??
> VARCHAR string [15]
>
>
> Olivier
>
>
>
Received on Wed Dec 08 1999 - 08:14:50 CST