The tonumber function will work:

select to_number('aeae','xxxxxxxxxx') from dual;


TO_NUMBER('AEAE','XXXXXXXXXX')
------------------------------
44718

Good Luck!
Chris

----------------------------------------------------
Chris Weiss, Blueoak Database Engineering, LLC
http://www.blueoakdb.com
PH: 517-579-3127
CELL: 517-974-5634
eFAX: 801-340-0740


-----Original Message-----
From: Jautse Thabo
[mailto:oracledba-ezmlmshield-x31480767.[Email address protected]
Sent: Friday, December 31, 2004 1:26 AM
To: LazyDBA Discussion
Subject: Hex to Ascii converter


Hi all,



Is there a tool out there that one can use to convert from hexadecimal
into ascii?

I tried using logminer to retrieve data from archive logs but as I had
done an export

it does not recognise the table names and data. I now have the
following:

update "unknown"."TABLE2" set "Col1" = HEXTORAW('6630303030303036'),
"Col20" = HEXTORAW('20') where ROWID = 'AAADnjAACAABFDBAAB';

I would like to convert the data to ascii so I can use it.



Regards,

Thabo




____________________________________________________________________________
_______________________


The views expressed in this email are, unless otherwise stated, those of the
author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider or
its management.
The information in this e-mail is confidential and is intended solely for
the addressee.
Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity
of information and data
transmitted electronically and to preserve the confidentiality thereof, no
liability or
responsibility whatsoever is accepted if information or data is, for
whatever reason, corrupted
or does not reach its intended destination.

________________________________


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page