Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name ( value ) AS
SELECT 37000 FROM DUAL;
1 rows affected

SELECT MOD( FLOOR( value / (256*256*256) ), 256 ) AS pos1,
       MOD( FLOOR( value / (256*256)     ), 256 ) AS pos2,
       MOD( FLOOR( value / 256           ), 256 ) AS pos3,
       MOD( value,                          256 ) AS pos4
FROM   table_name


POS1
POS2
POS3
POS4


0
0
144
136


SELECT HEXTORAW(TO_CHAR(value,'FM0XXXXXXX')) AS raw_value
FROM table_name;


RAW_VALUE


0x00009088