Re: binary to decimal conversion

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Tue, 14 Dec 1999 21:18:10 +0200
Message-ID: <385697F2.59D7DC4E@0800-einwahl.de>

Perhaps utl_raw packages has something for you.

Martin

brutus_1_at_my-deja.com wrote:
>
> I need to convert a binary number to decimal. How can I do it? I am
> using Oracle 8. I have just started using Oracle and an absolute novice
> in this area.
>
> I need to read a binary number off a field in my .dat file and interpret
> that number since that tells me how many records I am supposed to skip
> before I continue adding records to my table. I need to use this
> conversion function in my control file which I shall pass to SQL*Loader
> along with my .dat file to load the table.
>
> Since I am using DDL, how do I call a function in DDL? Do I create a
> trigger or a function? Suggestions!!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 14 1999 - 13:18:10 CST