Re: Varbinary in Oracle

> How can in Oracle convert a varbinary (0xCC) in decimal where cc is an
> HEX???
>
> 1)VARBINARY --> 0xCC
>
> 2)I would like to convert cc(HEX) in the corrispondent decimal value=204
>
> In Sybase I use this kind of syntax:
> select convert(tinyint, substring(0xcc, 1 ,1))
> The output is:
> 204

select to_number('CC','XX') from dual;

--
Noel