Create an Oracle Database 12c query that will be called from a Java web service
$30-250 USD
Оплачується при отриманні
I have a web service in Java that performs searches on an Oracle 12c Database. The problem is I have a CONTAINS() search:
String query = "select * from user.my_table WHERE CONTAINS(my_clob_field, '" + searchString + "', 1) > 0";
but I also want to get the index(es) of the search word or phrase within each result.
Your task is to come up with a query, that can be called from a Java web service, that will do what the above query does, but will also return the indexes of the search word or phrase.
Background:
Currently what I've tried is to take each of the returned search results and go through them performing a REGEX search in Java to find the start and stop indexes needed to highlight the search result on the front end.
This works fine for regular text but if the requirement is that the user can search for any random arrangement of any characters (i.e. #<(F#><$*>/\./#&!)#}{}][s fdf) the Java search needs to also find that exact string and return the start and stop index.
I escape out any special characters for the Oracle search, but an entirely different set of rules is needed for the Java search to find the index. Trying to get them to match up has turned out to be a nightmare and typically the Java REGEX search doesn't find the same occurrences that the Oracle Database CONTAINS() search finds. I believe there should be some simple way to also get the indexes of the occurrences of the search word (or phrase).
Your task is to come up with a query, that can be called from a Java web service, that will do what the above query does, but most importantly, will also return the indexes of the search word or phrase.
For example, say one of the records from a CONTAINS() query has 3 occurrences of the search word in it. Your query would also return the start and stop indexes of each of the three occurrences within the CLOB field.
ID Проекту: #9029233
Про проект
13 фрілансерів(-и) готові виконати цю роботу у середньому за $156
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Більше
Hi, I'm certified Oracle DBA and Oracle developer since 2000. You can contact with me at any moment to discuss your task.
Besides CONTAINS(), Oracle supports REGEXP functions (since 10g); and I think these functions fit your task ideally.
I have good knowledge of Java and Oracle . I already worked on Java , Oracle , Java Web services etc.
I have good experience with SQL db and Java . Please allow me to take a look at your requirement. Please specify the time line that you accept it to be completed. Thanks
We have experience in developing desktop application, web and mobile. We have a partnership with a company in northern Brazil, which is franchise of Coca-Cola Brazil.
I have 10 years experience working in Oracle Database. I have 10 years experience iworking n Oracle Database.