Home » RDBMS Server » Server Administration » Need to get the hex value of a character column. (Oracle 10g)
Need to get the hex value of a character column. [message #352316] Tue, 07 October 2008 01:30 Go to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi,
I have a Japanese data base and I need to see the hex values of the char columns from a table how can I do this.

Thanks in Advance
Re: Need to get the hex value of a character column. [message #352324 is a reply to message #352316] Tue, 07 October 2008 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select dump('michel',16) from dual;
DUMP('MICHEL',16)
-------------------------------
Typ=96 Len=6: 6d,69,63,68,65,6c

1 row selected.

Regards
Michel
Re: Need to get the hex value of a character column. [message #352334 is a reply to message #352324] Tue, 07 October 2008 03:16 Go to previous messageGo to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi Michel,
I need to read from the row but I guess the SQL you gave will give the hex of string 'michel'. But if I have a data already in the column and i need to read the char data which is already in the table, what can I do ?
Re: Need to get the hex value of a character column. [message #352346 is a reply to message #352334] Tue, 07 October 2008 03:59 Go to previous message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Thanks Michel,
Now I got it from your comment.

SQL> select dump(MyTable.colname,16) from MyTable;

is yielding me the expected result. Smile
Previous Topic: Synonym For Procedure
Next Topic: When oracle mark the session INACTIVE?
Goto Forum:
  


Current Time: Sat Dec 03 22:17:47 CST 2016

Total time taken to generate the page: 0.05539 seconds