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 -> Re: Implied decimal points in external tables

Re: Implied decimal points in external tables

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 02 Sep 2004 05:59:01 GMT
Message-ID: <FEyZc.86097$X12.66469@edtnps84> 





Phil Bewig wrote:



> but that doesn't work with external tables.  I've played

> with decimal, zoned, and external but don't yet know how

> to properly read that number.




ROT:  If YOU can read the number in the underlying source file, it is not a
number.  It is a character string that happens to contain only numeric
digits.  



Try a 'to_number()' conversion.


/Hans
Received on Thu Sep 02 2004 - 00:59:01 CDT












Original text of this message













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