Skip to Main Content

how to use EQUIV operator in a query?

Cheney ShueJan 9 2009 — edited Jan 9 2009
i want to list products whose names like 'Windows XP' or 'WindowsXP', following is my query:

select * from product
where contains(product_name,'Windows XP = WindowsXP',1) > 0

but this query only return the products whose name contain 'Windows XP'. the result is something likes

select * from product
where contains(product_name,'Windows (XP = WindowsXP)',1) > 0

so i modified it to :

select * from product
where contains(product_name,'(Windows XP) = (WindowsXP)',1) > 0

it's error
Error report:
SQL Error: ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-50900: text query parser error on line 1, column 26
DRG-50921: EQUIV operand not a word or another EQUIV expression
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.
Post Details
Added on Jan 9 2009
1 comment