OraFAQ Forum: Server Administration » Need to get the hex value of a character column.

Home » RDBMS Server » Server Administration » Need to get the hex value of a character column. (Oracle 10g)

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

Need to get the hex value of a character column. [message #352316]

Tue, 07 October 2008 01:30

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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 ?

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Synonym For Procedure
Next Topic:	When oracle mark the session INACTIVE?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 17:51:15 CST 2024