Re: Oracle hexadecimal query

On Mar 6, 5:26 am, nivS1..._at_gmail.com wrote:
> 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...- Hide quoted text -
>
> - Show quoted text -

Without the Oracle release to at least four numbers, the DDL to create the table and some sample data to illustrate your point it's difficult, if not impossible, to provide you an answer.

Provide the requested information.

David Fitzjarrell Received on Thu Mar 06 2008 - 07:08:23 CST