binary to decimal conversion

From: <brutus_1_at_my-deja.com>
Date: Wed, 08 Dec 1999 16:46:40 GMT
Message-ID: <82m21d$dcm$1@nnrp1.deja.com>

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 Wed Dec 08 1999 - 10:46:40 CST