RE: How do you display hex via SQL
- From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jul 2004 23:38:36 -0400
select to_char(123456,'XXXXXXXXXXXXXXX') from dual;
1E240
select to_number(' 1E240','XXXXXXXXXXXXXXX') from dual;
123456
Waleed
-----Original Message-----
From: Warren Homer [mailto:wazhomer@xxxxxxxxxxx]=20
Sent: Thursday, July 15, 2004 10:27 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
