Please consider the following case.
I have an index named : FRAUD
I would like to display all the documents that field A is equal to field B
fields A and B are of string data type.
in sqlplus its looks like that
select a,b,c from FRAUD where a=b;