Re: ** help with query?

From: Jack <jackbader_at_gmail.com>
Date: 8 Mar 2006 10:46:16 -0800
Message-ID: <1141843576.188583.56980@z34g2000cwc.googlegroups.com>

Jim,

One last question, I think. I have found the table and field that I was looking for. Let's simplify it and say the table is CUSTOMER and the field is BALANCE and there is only one row.

BALANCE is the varchar2(10) field. I would like to display the Hex value of this field from the sqlplus prompt. I was looking at the to_char function but am not sure how to do this.

Could you help me with the Select that would display the hex value of BALANCE? Thanks,
Jack Received on Wed Mar 08 2006 - 12:46:16 CST