Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ** numeric check

** numeric check

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Mon, 12 Jul 2004 14:29:04 -0700 (PDT)
Message-ID: <20040712212904.6102.qmail@web60706.mail.yahoo.com>


Hi,
  I have a varchar2 column which contains some text and some totally numeric values. Is there an easy way to check if the value is totally numeric instead of looking at ascii values etc. Thanks for your help.                 



Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
Received on Mon Jul 12 2004 - 16:25:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US