| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_01BFC400.DDCE5316
Content-Type: text/plain;
charset="iso-8859-1"
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_01BFC400.DDCE5316
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Negatives in Sqlloader</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">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 SIZE=3D2 FACE=3D"Arial">Thank you in advance,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Laura</FONT>
</P>
</BODY>
</HTML>
Received on Mon May 22 2000 - 10:17:34 CDT
 |
 |