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 fixed format and number format

Re: SQLLDR fixed format and number format

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Mon, 19 Sep 2005 18:49:34 +0200
Message-ID: <dgmpvf$d81$1@news1.zdv.uni-mainz.de>


Maxim Demenko schrieb:

> Now i got it too, it seems, by using of 'G' + is not more optional, and
> by combination 'SG' all numbers must be signed. So, i would suggest use
> of only 'G' modifiers and ltrim all '+' signs (i.e.
> open_int_change_prev position(138:147)
> "to_number(ltrim(:open_int_change_prev,'+'),'S99G999')" ).

Shouldn't this be '99G999' because you eliminated all '+' signs?

> Btw, if you would post the ddl of your table ( as well as your plattform
> and db version) , it would be easier to reproduce your problem, so you
> would increase the chance to get valuable response.

Plattform:

	Windows Server 2003
	Oracle 10.1.0.3

Thanks,

   Moritz Received on Mon Sep 19 2005 - 11:49:34 CDT

Original text of this message

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