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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to tell oracle SQL*Loader thousand seperating character?

Re: How to tell oracle SQL*Loader thousand seperating character?

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 25 Sep 2005 12:54:22 -0700
Message-ID: <1127678062.511523.203720@g43g2000cwa.googlegroups.com> 





You could remove the commas from that column in your SQL*Loader control
file, like so:



your_column "replace (:your_column, '.', '')"



This assumes that something else is used for decimals and that the dot
is not used as a field terminator.
Received on Sun Sep 25 2005 - 14:54:22 CDT












Original text of this message













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