rawtohex

See strange data in your Oracle tables? The standard rawtohex function lets you see whats in there.

Snippet:

SELECT RAWTOHEX(FIELD)
from TABLE