RE: Decimal to Hex conversion

From: Dasko, Dan <Dan.Dasko_at_cdicorp.com>
Date: Thu, 08 Feb 2001 08:24:53 -0800
Message-ID: <F001.002AEFAD.20010208065140@fatcity.com>

rawtohex()

-----Original Message-----
Sent: Thursday, February 08, 2001 5:15 AM To: Multiple recipients of list ORACLE-L

Hi everybody,

I am facing a problem converting from decimal values to hexadecimal values.

i.e.

col1 col2

2021 801

should give (2021*65536+801)=132449057

I am asked to present this value in hexView like : 07E50321

any suggestions howto convert (probably via simple SQL) ?????

TNX
> Frank Foelz <

sorry, but I posted this to ODTUG-SQLPLUS-L_at_fatcity.com, already. We are facing problems
with some mailservers today.....

Scheidt & Bachmann GmbH
Gestaltung Parkhaussysteme
Breite Strasse 132
41238 Moenchengladbach

Phone : ++49 2166 / 266 - 837
Fax: ++49 2166 / 266 - 615
e-mail : mailto:Foelz.Frank_at_Scheidt-Bachmann.de URL : http://www.scheidt-bachmann.de

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Foelz.Frank
  INET: Foelz.Frank_at_Scheidt-Bachmann.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_____________________________________________________________________
This message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: Dan.Dasko_at_cdicorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 08 2001 - 10:24:53 CST