Use “Get full text” to get the table contents in the application system developed by Oracle,the output string is unordered,this problem only occurs under the Oracle app system.
Does anyone know how to solve it?
Indeed, java app integration can cause weird behaviours from time to time (depending on the java application).
The suggestion of what to do depends on your requirements. For example, you could try to find some logic in the way the text is scrapped.
Another suggestion would apply if you want to select a specific value. It worked for me, so maybe it will work for you too. You can actually type in your desired value inbetween % sings, like this:
%yourvalue%
in the Find box and click on ‘Find’. If the value was unique, it should select it automatically.
Thank you for your reply, yes, you are right, fuzzy query be able to reduce the number of query records, but sometimes the amount of data is still big, and there is no logic, according the total number of occurrences in the query results, the order after output is different.
Now, I can only use a very stupid way to use the Switch Case to locate. . .