1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| with data as (
select level-1 as n from dual
connect by level <= 256
)
select n, to_char(n, 'XXXXXXXXXXX') as hex, substr('00000000000000000000000000000000' || replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(replace(to_char(n, 'XXXXXXXXXXX'),' ',''),'0','0000')
,'1','0001')
,'2','0010')
,'3','0011')
,'4','0100')
,'5','0101')
,'6','0110')
,'7','0111')
,'8','1000')
,'9','1001')
,'A','1010')
,'B','1011')
,'C','1100')
,'D','1101')
,'E','1110')
,'F','1111'),-32) as to_binary
from data; |
Partager