Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Search on raw field

Search on raw field

From: Young Lee <young_at_durand.com>
Date: 1997/08/08
Message-ID: <5sgi18$are@news0-alterdial.uu.net>#1/1

Can I search on raw field? If so, what is the correct statement. I tried the following statements and none of them returns any rows. It should return some rows.

The field ID is defined as raw(255)

select ID from tableA where rawtohex(ID) > 1 select ID from tableA where rawtohex(ID) > rawtohex(1) select ID from tableA where ID > Hextoraw(1)

Thank you,
Young Lee Received on Fri Aug 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US