| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Negatives in Sqlloader
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFC41E.2150CE30
Content-Type: text/plain;
charset="iso-8859-1"
Laura,
I did ran into similar problem before.
I managed it with data type as INTEGER EXTERNAL on that field in the .ctl
file
hope this helps.
Sunil Nookala
-----Original Message-----
From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com]
Sent: Monday, May 22, 2000 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Negatives in Sqlloader
Using SqlLoader, has anyone handled negative amounts? I have downloaded into a text file the amounts with a negative sign in the first position of the field. If it is not negative there is a blank there. I am having trouble gettting sqlldr to run. Anyone have any experience with this? How do you 'format' the .ctl member to recognize the '-' as being a negative?
Thank you in advance,
Laura
------_=_NextPart_001_01BFC41E.2150CE30
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Negatives in Sqlloader</TITLE>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=377053818-22052000>Laura,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>I did
ran into similar problem before.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>I
managed it with data type as <STRONG>INTEGER EXTERNAL </STRONG>on that field in
the .ctl file</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>hope
this helps.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=377053818-22052000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=377053818-22052000>Sunil
Nookala</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Burton, Laura L.
[mailto:BurtonL_at_prismplus.com]<BR><B>Sent:</B> Monday, May 22, 2000 11:39
AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
Negatives in Sqlloader<BR><BR></DIV></FONT>
<P><FONT face=Arial size=2>Using SqlLoader, has anyone handled negative
amounts? I have downloaded into a text file the amounts with a negative
sign in the first position of the field. If it is not negative there is
a blank there. I am having trouble gettting sqlldr to run. Anyone
have any experience with this? How do you 'format' the .ctl member to
recognize the '-' as being a negative?</FONT></P>
<P><FONT face=Arial size=2>Thank you in advance,</FONT> </P>
<P><FONT face=Arial size=2>Laura</FONT> </P></BLOCKQUOTE></BODY></HTML>
Received on Mon May 22 2000 - 13:47:02 CDT
 |
 |