Re: sql loader --Need Help
From: Matt B. <mcb_at_sd.znet.com>
Date: Tue, 29 May 2001 21:54:58 -0700
Message-ID: <th8v61467s3s0c_at_corp.supernews.com>
Date: Tue, 29 May 2001 21:54:58 -0700
Message-ID: <th8v61467s3s0c_at_corp.supernews.com>
"anuragmin" <anurag_minocha_at_hotmail.com> wrote in message
news:893.990795302194_at_iw0.mailusenet.com...
>I tried all possible altrernatives using translate, decode, replace etc but
without any success.
Decode didn't work? Offhand I would think it would if you define the field as a character and then decode it - if 'N/A', return null, else apply and return a to_number on the field's value.
Can't try it offhand (I'm at home - no DB access) but I would think it'd work...?
-Matt Received on Wed May 30 2001 - 06:54:58 CEST