PL/SQL (MOSC)

MOSC Banner

Converting from base64 to Raw

The below command converts raw value 'b562b3b63a1b4f41bf6a3a95770550d6' to base64 value 'AbVis7Y6G09Bv2o6lXcFUNY='

SQL> select utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4))) || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64 FROM (select 'b562b3b63a1b4f41bf6a3a95770550d6' mkeyid from dual);

MASTERKEYID_BASE64

--------------------------------------------------------------------------------

AbVis7Y6G09Bv2o6lXcFUNY=


I'm looking for reverse conversion from input 'AbVis7Y6G09Bv2o6lXcFUNY=' to output 'b562b3b63a1b4f41bf6a3a95770550d6'.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center