Oracle hexadecimal query

From: <>
Date: Thu, 6 Mar 2008 03:23:45 -0800 (PST)
Message-ID: <>

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... Received on Thu Mar 06 2008 - 05:23:45 CST

Original text of this message