Re: varchar2 to hex/octal ... convert string

From: Frank van Bortel <fbortel_at_home.nl>
Date: Wed, 15 Sep 2010 10:10:14 +0200
Message-ID: <d71c3$4c907f66$524ba3af$9622_at_cache4.tilbu1.nb.home.nl>

On 09/12/2010 07:07 PM, okey wrote:
> is there way to 'dump' a string (varchar2) to the screen in hex?
>
> "this is a string" would print something like "33 44 23 64 345 43
> 34 ..." (I just made that up)
>
> We started using unicode and there are a few fields that should match
> but do not. We have to see below the characters printed to the
> screen. Something snuck in there.
>
> We tried using Toad's grid editor to look at this field, but it
> crumps. Strange.
>
> select char_to_hex(field) from table;
>
> Thank you.
> 10g

select dump(column1,16) from tablea;

You owe me a cup of coffe for reading the manual for you

-- 

Regards,

Frank van Bortel

Received on Wed Sep 15 2010 - 03:10:14 CDT