Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail
From: DMina@laiki.com (Demetris)
Newsgroups: comp.databases.oracle,comp.databases.oracle.server
Subject: SQL Loader
Date: 8 Sep 2004 23:41:28 -0700
Organization: http://groups.google.com
Lines: 19
Message-ID: <c5285638.0409082241.4bc26bcc@posting.google.com>
NNTP-Posting-Host: 212.31.98.140
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1094712089 29371 127.0.0.1 (9 Sep 2004 06:41:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Sep 2004 06:41:29 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle:28668 comp.databases.oracle.server:224555

Hello there!
I am trying to read from a text file and load a table in ORACLE8i.
For example I have the following line:

00000405152-00000005152-0000000400000

and my table is as follows:

num1  number(11,2)
num2  number(11,2)
num3  number(13,2)

The first number as you can see from the line above should be negative (the
dash between the first two number).
My question is how can I load that and tell ORACLE that it is a negative
number?

Thanks
Demetris