benbotektips
MIS
Any way to convert a number field to its binary equivalent (ex. BINARY(15) = 1111, BINARY(13) = 1101 )?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
col a heading "Base|Conversions" format a11
select baseconv(1111,2,10) a from dual;
Base
Conversions
-----------
15
select baseconv(1101,2,10) a from dual;
Base
Conversions
-----------
13
select baseconv('1234567890abcdefghijklmnopqrstuvwxyz',36,16) from dual;
BASECONV('1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ',36,16)
------------------------------------------------------
20A45C4A82A3EB406AF773B5C3F6BBB6ABA606A213EA58