Oracle hexadecimal query
From: <nivS1978_at_gmail.com>
Date: Thu, 6 Mar 2008 03:23:45 -0800 (PST)
Message-ID: <e0444969-3c16-441f-bb58-d82061b14a08@n58g2000hsf.googlegroups.com>
Date: Thu, 6 Mar 2008 03:23:45 -0800 (PST)
Message-ID: <e0444969-3c16-441f-bb58-d82061b14a08@n58g2000hsf.googlegroups.com>
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