Re: Numeric Function

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 8 Nov 2001 13:44:30 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7350173@lnewton.leeds.lfs.co.uk>

Even better, replace :

      SELECT TO_NUMBER(in_value) INTO dummy FROM dual;

with

      dummy := TO_NUMBER(in_value);

I don't write that much PL/SQL so I screwed up first time - sorry.

Works with stuff like '-1e-6' etc - might as well get Oracle to do the hard work of figuring out what a number is or isn't !

regards,
Norman.

---

---

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

---

-----Original Message-----

From: Norman Dunbar
Posted At: Thursday, November 08, 2001 12:48 PM Posted To: server
Conversation: Numeric Function
Subject: Re: Numeric Function

CREATE OR REPLACE FUNCTION Is_Numeric(in_value IN VARCHAR2) RETURN INTEGER IS
      dummy NUMBER;
   BEGIN

      SELECT TO_NUMBER(in_value) INTO dummy FROM dual;
      RETURN 1;
   EXCEPTION
      WHEN OTHERS THEN
      RETURN 0;  

   END Is_Numeric;
/

<SNIP> Received on Thu Nov 08 2001 - 07:44:30 CST