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: sqlldr and decimal delimiters

Re: sqlldr and decimal delimiters

From: EpiteamB <carmanetREM_at_epicentre.fr>
Date: Thu, 13 Mar 2003 17:23:59 +0100
Message-ID: <b4qbdg$v6l$1@news-reader0.wanadoo.fr> 





I'm not sure, but I don't think so...


You should use "DECIMAL EXTERNAL" with POSITION to declare the field in the
controlfile for sqlldr,


and use SQL functions such as DECODE, SUBSTR, TO_NUMBER ... to make
sql*loader know what is the decimal


delimiter for you.



Céline.



"Christoph Seidel" <christoph.seidel1_at_gmx.de> a écrit dans le message news:
b4q5rj$21kfrl$1_at_ID-143718.news.dfncis.de...


> hi,

>

> is there a way how i can set the decimal delimiter for sqlldr?

>

>

Received on Thu Mar 13 2003 - 10:23:59 CST












Original text of this message













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