Re: Oracle hexadecimal query

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