While working with one of the oracle requests, when I run the select command with a condition something like:
select * from table_name where contains(address,'"IN%" AND "BÖDEN%"') >0
No results are displayed as part of this query, although the results are in the database.
Again, if I enter one space between "IN" and "%", I get the correct results:
select * from table_name where contains(address,'"IN %" AND "BÖDEN%"') >0
There is one more scenario:
The same queries, but if "IN" is replaced by "IM", the corresponding results are displayed.
select * from table_name where contains(address,'"IM%" AND "BÖDEN%"') >0
or
select * from table_name where contains(address,'"IM %" AND "BÖDEN%"') >0
Both of the above queries give the same results. which is also obvious.
Therefore, I suspect that there is something special with "IN" in the oracle.
Can someone suggest me the correct cause of this problem and any solution to the problem?
source
share