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

From: Mladen Gogala <no_at_email.here.invalid>
Date: Mon, 13 Sep 2010 18:31:11 +0000 (UTC)
Message-ID: <pan.2010.09.13.18.31.11_at_email.here.invalid>

On Sun, 12 Sep 2010 19:57:06 +0200, Michel Cadot wrote:

> SQL> select dump('michel',16) from dual; DUMP('MICHEL',16)
> -------------------------------
> Typ=96 Len=6: 6d,69,63,68,65,6c

Just to clarify the remaining issues:
For octal dump, it's
SQL> select dump('michel',8) from dual;

DUMP('MICHEL',8)

---

Typ=96 Len=6: 155,151,143,150,145,154

Elapsed: 00:00:00.10

For the strictly numeric conversion, there is a good article here: http://tkyte.blogspot.com/2009/10/httpasktomoraclecomtkytehexdec.html

-- 
http://mgogala.byethost5.com

Received on Mon Sep 13 2010 - 13:31:11 CDT