Re: decimal to hexadecimal conversion

Andrea Carrara wrote:
>
> I don't know how to convert a number in hexadecimal format.
> What I want to do is something like this:
>
> SELECT HEX(value) FROM baubau
>
> But on the manual I haven't found anything useful.
>
> I'm using Oracle 8 on Linux.
>
> Anyone can help me?
>
> Thanks, Andrea Carrara.

There is a format mask to do this in 8.1.6, before that, check out

http://osi.oracle.com/~tkyte

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse