From Dan.Dasko@cdicorp.com Thu, 08 Feb 2001 08:24:53 -0800 From: "Dasko, Dan" Date: Thu, 08 Feb 2001 08:24:53 -0800 Subject: RE: Decimal to Hex conversion Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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@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@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@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).