SELECT v from T where v[3]=4
sql> create table test (a raw(16)); Table created sql> insert into test values ('FF00FF00FF'); 1 row inserted sql> select * from test where utl_raw.substr(a,3,1) = 'FF'; A -------------------------------- FF00FF00FF
