OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql [message #20854]

Tue, 25 June 2002 20:20

moloy
Messages: 8
Registered: June 2002

Junior Member

How can i convert char data to hexadecimal and vice versa in oracle

Report message to a moderator

Re: sql [message #20855 is a reply to message #20854]

Tue, 25 June 2002 22:31

Maaher
Messages: 7065
Registered: December 2001

Senior Member

The numeric format 'X' defines hexadecimal.

SQL> select to_char(123,'XXX') from dual;

TO_C
----
  7B

SQL> select to_number('7B','XXX') from dual;

TO_NUMBER('7B','XXX')
---------------------
                  123

HTH,
MHE

Report message to a moderator

Re: sql [message #20859 is a reply to message #20854]

Wed, 26 June 2002 00:45

moloy
Messages: 8
Registered: June 2002

Junior Member

but maher

u are passing number argument.
Actually i need to pass character
and get hexadecimal in return..

moloy

Report message to a moderator

Re: sql [message #20866 is a reply to message #20854]

Wed, 26 June 2002 09:17

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

sql>select rawtohex('moloy') tohex from dual;
 
TOHEX
----------
6D6F6C6F79
 
sql>select utl_raw.cast_to_varchar2(hextoraw('6D6F6C6F79')) fromhex from dual;
 
FROMHEX
------------------------------------------------------------------------------
moloy

Report message to a moderator

Previous Topic:	nested sql statement
Next Topic:	Controlling number of employees in specific department

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:22:52 CDT 2024