If anyone has experience using Oracle text (CTXSYS.CONTEXT), I'm wondering how to handle user input when the user wants to search for names that may contain an apostrophe. Escaping the ' seems to ...

We want to use a ctxsys.context index type for full text search. But I was quite surprised, that an index of this type is not automatically updated. We have 3 million documents with about 10k updat...

I want to be able to escape the search criteria in an Oracle text query using contains and combine the escaped criteria with wildcards to have "doubly truncated" criteria. (I know my indexes may no...

Is it possible to perform a JPA Criteria Query using Oracle Text's contains statement, and if so how?

I have an Oracle database that, like many, has a table containing biographical information. On which, I would like to search by name in a "natural" way. The table has forename and surname fields a...

I've created an Oracle Text index like the following: create index my_idx on my_table (text) indextype is ctxsys.context; And I can then do the following: select * from my_table where contains...

I have a set of Oracle tables that describe information about property owners. Owner names and other text values are stored in multiple fields in multiple related tables, for each owner. I would li...

Is there an Oracle equivalent to MS SQL's full text search service? If so, has anyone implemented it and had good / bad experiences?