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

Home -> Community -> Usenet -> c.d.o.misc -> Dumb newbie question; how to identify numerics.

Dumb newbie question; how to identify numerics.

From: Jaywalk <jaywalk_at_techie.com>
Date: 30 Jan 2003 10:31:58 -0800
Message-ID: <8f27f83a.0301301031.5804c48b@posting.google.com> 





This is embarassing.  I can't for the life of me remember how to get a
query to return results only when a certain VARCHAR2 field is not
numeric.  Some of the fields are numeric and some are not, but I can't
do something like "to_number(fieldname)" to figure out which ones are
numeric because it blows up on the first non-numeric.



I've been through the manuals, FAQs and past posts and I'm still
coming up blank.  Is there a kind soul out there who can help me past
this brain cramp I'm having?



Any help would be appreciated.



Jaywalk
Received on Thu Jan 30 2003 - 12:31:58 CST












Original text of this message













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