| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Decimal to Hex conversion
Hi helpers,
just a note to say thank you, to everyone who gave me hints, packages and func.s !!!
Great maillist !!!
TNX
> Frank Foelz <
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
-----Ursprüngliche Nachricht-----
Von: Foelz.Frank [mailto:Foelz.Frank_at_scheidt-bachmann.de]
Gesendet am: Donnerstag, 8. Februar 2001 11:15
An: Multiple recipients of list ORACLE-L
Betreff: Decimal to Hex conversion
Hi everybody,
I am facing a problem converting from decimal values to hexadecimal values.
i.e.
col1 col2
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.....
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). -- 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 Fri Feb 09 2001 - 01:05:58 CST
 |
 |