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!

Converting from BASE 64 to Decimal Base 10

470436Mar 12 2013 — edited Mar 12 2013

I have an requirement to convert a value from base 64 to decimal base 10
for ex if i give b the resultant output should be 27
as per the website -- http://convertxy.com/index.php/numberbases/

I tried using the UTL_ENCODE.BASE64_ENCODE with UTL_RAW.CAST_TO_RAW

select utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw('b'))) from dual

but i am not getting the desired result

Kindly guide me in this issue

With Warm Regards
SSR

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2013

Added on Mar 12 2013

7 comments

2,576 views