Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Search on raw field
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
![]() |
![]() |