rawtohex 와 chr 사용

select  rawtohex(comp_cd) as rowhex, replace(comp_cd,chr(00),'♨')||'abc'
from    tb_imsi a