Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8PHxOt16611 for ; Thu, 25 Sep 2003 12:59:24 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8PHxMc16605 for ; Thu, 25 Sep 2003 12:59:23 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8PFKZS17959 for oracle-l@orafaq.net; Thu, 25 Sep 2003 08:20:35 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D10DF; Thu, 25 Sep 2003 08:19:46 -0800 Message-ID: Date: Thu, 25 Sep 2003 08:19:46 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "AK" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "AK" Subject: Re: equivalent for isdate, isnumeric Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am not sure if there is any such function in 9i . But you can definnitely accomplish this by writing your own function something like function isNum(a varchar2) returns boolean is begin b := tonumber(a); result = true; return result; exception when (numer or value error) -- get proper exception result=false return result; end; same can be done for isDate as well. -ak ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Thursday, September 25, 2003 8:34 AM > Hi All, > > I am investigating an effort to move our product into Oracle from SQL Server. Came across the function isnumeric, isdate in SQL Server that returns true or false if the input string is in a form that can be converted into a numeric or date type. searched in oracle help and am not able to find an equivalent. Is there any equivalent form of these functions in Oracle?? > > Thanks, > ShivaM > > DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged. > It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, > please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use, > save, disclose, distribute, copy, print or relay this e-mail. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Shiva Maran > INET: Shivam@talisma.com > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: oramagic@hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).