bin to dec

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 Thu Dec 09 1999 - 09:14:18 CST