Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Binary to Decimal Conversion

443470Aug 18 2006 — edited Aug 21 2006
Hi,

I am using Oracle 10g and I have binary numbers stored in varchar2 column, like ‘0100101110’. What would be the best way to convert that binary to decimal?

I am hoping that there is a built-in PLSQL function to do that.

Thank you,
Alan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2006
Added on Aug 18 2006
22 comments
3,838 views