display character directly from raw field

Hi,

From Oracle manual, there are two function : hextoraw and rawtohex, from hextoraw I can convert hex string become raw type and save it.

But when I retrieve it, it will automatic convert as hex and display, does any way to force program does not convert it and display as string.

e.g.

select hextoraw('4142'), rawtohex('AB') from dual;

==> 4142 4142

And what I need is :

==> AB 4142

Thanks.

Jung-Pin  

-- 
Sent  by jungpin.wang  from usa subpart of  net
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new