How Oracle databases are converted

Conversion of Oracle database into system

Oracle Database conversion:
1.16 Binary conversion to 10-system

Can be implemented through the To_number function:

Select To_number (' 19f ', ' xxx ') from dual;
----------------------
415
Select To_number (' F ', ' xx ') from dual;
-------------------
15

2.10 Binary conversion to 16-system

We can convert by To_char function:

Select To_char (123, ' xx ') from dual;
----
7b
Select To_char (4567, ' xxxx ') from dual;
-----
11d7

3.2 Binary conversion to 10-system

Starting with Oracle9i, the conversion of function Bin_to_num to 2 to 10 is provided:

Select Bin_to_num (1,1,0,1) a,bin_to_num (1,0) b from dual;
A B
----- ----------
13 2
Select Bin_to_num (1,1,1,0,1) from dual;
Bin_to_num (1,1,1,0,1)
---------------------
29