From oracle-l-bounce@freelists.org Thu Jul 15 22:35:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6G3ZBd26076 for ; Thu, 15 Jul 2004 22:35:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6G3Yp626052 for ; Thu, 15 Jul 2004 22:35:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 89ACF72C36D; Thu, 15 Jul 2004 22:14:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26664-69; Thu, 15 Jul 2004 22:14:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D7CF872C0BB; Thu, 15 Jul 2004 22:14:57 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Jul 2004 22:13:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C1C1E72C073 for ; Thu, 15 Jul 2004 22:13:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26696-44 for ; Thu, 15 Jul 2004 22:13:30 -0500 (EST) Received: from maillnx-us311.fmr.com (maillnx-us311.fmr.com [192.223.178.26]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A82E72C02D for ; Thu, 15 Jul 2004 22:13:30 -0500 (EST) Received: from virmro111nts.fmr.com (virmro111nts.fmr.com [172.26.5.99]) by maillnx-us311.fmr.com (Switch-3.1.2/Switch-3.1.0) with SMTP id i6G3cb9q012034 for ; Thu, 15 Jul 2004 23:38:37 -0400 Received: from MSGBOSCLF2WIN.fmr.com ([10.46.17.175]) by MSGMROIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.6713); Thu, 15 Jul 2004 23:38:36 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message Subject: RE: How do you display hex via SQL MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Date: Thu, 15 Jul 2004 23:38:36 -0400 Message-ID: <42BBD772AC30EA428B057864E203C99927445F@MSGBOSCLF2WIN.DMN1.FMR.COM> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How do you display hex via SQL Thread-Index: AcRq3hzajfePZlRLQweciX4ZP9SYlAACDrsg From: "Khedr, Waleed" To: X-OriginalArrivalTime: 16 Jul 2004 03:38:36.0690 (UTC) FILETIME=[607ACF20:01C46AE6] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5284 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Waleed.Khedr@FMR.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org select to_char(123456,'XXXXXXXXXXXXXXX') from dual; 1E240 select to_number(' 1E240','XXXXXXXXXXXXXXX') from dual; 123456 Waleed -----Original Message----- From: Warren Homer [mailto:wazhomer@hotmail.com]=20 Sent: Thursday, July 15, 2004 10:27 PM To: oracle-l@freelists.org Subject: How do you display hex via SQL Hi , is there a way via Oracle SQL to display the hex representation of a number. e.g select hex(57) from dual; 39 Thanks in advance. Warren. _________________________________________________________________ Smart Saving with ING Direct - earn 5.25% p.a. variable rate: =20 http://ad.au.doubleclick.net/clk;7249209;8842331;n?http://www.ingdirect. com.au/burst6offer.asp?id=3D8 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------