Re: Sql*Loader
From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/06/23
Message-ID: <33AE04EB.1A10_at_postoffice.worldnet.att.net>#1/1
Nilesh Bowan wrote:
>
> Hi
> I'm new to sql*loader, so my problem will probably be a small one o
> most of you.
> Two of the fields that I am working with are SIGN and REVENUE.
> SIGN has either a value of +1 or -1; REVENUE is a numeric
> value.
>
> How do I use sql*loader to concatenate the + or - from SIGN
> to the REVENUE value.
>
> eg) SIGN = -1; REVENUE = 323123 And I want -323123
>
> Please reply by email to :
> bowann_at_mwp.eskom.co.za
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Jun 23 1997 - 00:00:00 CEST
Date: 1997/06/23
Message-ID: <33AE04EB.1A10_at_postoffice.worldnet.att.net>#1/1
Try this:
"decode(:SIGN,+1,:REVENUE,-1,-:REVENUE)"
The string above *must* be the last element in the descriptor of the REVENUE field in your SQL*Loader control file. It *must* be entered as above, enclosed in double quotes and the two fields, SIGN and REVENUE, *must* each be preceded by the colon(:). I am not so sure if the minus(-) sign is before or after the :. You have to experiment or use 0(zero)-:REVENUE.
Hope this helps.
Nilesh Bowan wrote:
>
> Hi
> I'm new to sql*loader, so my problem will probably be a small one o
> most of you.
> Two of the fields that I am working with are SIGN and REVENUE.
> SIGN has either a value of +1 or -1; REVENUE is a numeric
> value.
>
> How do I use sql*loader to concatenate the + or - from SIGN
> to the REVENUE value.
>
> eg) SIGN = -1; REVENUE = 323123 And I want -323123
>
> Please reply by email to :
> bowann_at_mwp.eskom.co.za
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Jun 23 1997 - 00:00:00 CEST