Re: hexdump in select statement
From: Scott Mattes <scottmattes_at_yahoo.com>
Date: 18 Dec 2001 11:39:08 -0800
Message-ID: <3b5a8fb4.0112181139.6d435ad1_at_posting.google.com>
61626364
Date: 18 Dec 2001 11:39:08 -0800
Message-ID: <3b5a8fb4.0112181139.6d435ad1_at_posting.google.com>
[Quoted] SQL> select rawtohex( 'abcd' ) from dual;
RAWTOHEX
61626364
SQL>
Detlef Jockheck <djockheck_at_gauselmann.de> wrote in message news:<fplnv9.hvc.ln_at_java>...
> Hi,
>
> I've a table that seems to contain some strange values. Is there
> a way to produce a hexdump of a column?
> I'm looking for something like:
>
> select string,hexdump(string) of atable where id=4711;
>
> ciao
> Detlef
Received on Tue Dec 18 2001 - 20:39:08 CET