Re: SQL*Loader with external SIGNED numbers?
From: Don Fraser <don_at_clear.net.nz>
Date: 1998/01/25
Message-ID: <6add1o$sjs$1_at_titania.telstra.net.nz>#1/1
Date: 1998/01/25
Message-ID: <6add1o$sjs$1_at_titania.telstra.net.nz>#1/1
JosephS221 wrote in message
<19980122202700.PAA18954_at_ladder01.news.aol.com>...
>Hello!
>
>I am trying to load a character file via SQL*Loader. However, many of the
>numbers are signed, with the sign on the right (i.e., 12345+ or 98765- ).
>
>How can this be handled? I want to move them to a number field, or course.
You can use Oracle functions in SQL loader so move the sign to the left
Don Fraser - Aotea Software Received on Sun Jan 25 1998 - 00:00:00 CET