Re: Oracle hexadecimal query
Date: Thu, 6 Mar 2008 03:26:44 -0800 (PST)
On 6 Mar., 12:23, nivS1..._at_gmail.com wrote:
> A quick and simple question.
> If I have a query like:
> SELECT * FROM table NUM = 31
> Now for reasons irelevant to my question the number provided is
> hexadecimal. I could ofcourse in the program convert this to a number
> but is there a syntax in oracle to use similar to the sql server:
> SELECT * FROM table NUM = 0x1F
> How do I write this in oracle?
> I know I can do a to_num('1F','XX') or something like that but is
> there a way to just write a hexadecimal number directly?
> Regards Hans Milling...
I ofcourse forgot a WHERE...
SELECT * FROM table WHERE num = 0x1F
Also the column is of type int/number or something like that, not a raw.
Hans... Received on Thu Mar 06 2008 - 05:26:44 CST