Decimal to Hex conversion

From: Foelz.Frank <Foelz.Frank_at_scheidt-bachmann.de>
Date: Thu, 08 Feb 2001 03:15:50 -0800
Message-ID: <F001.002AEB26.20010208021524@fatcity.com>

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).

Received on Thu Feb 08 2001 - 05:15:50 CST