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 like to index the contents of these fields. My goal is to provide a single field where a user can enter keywords to locate owners. How do I set...
Hi all, I have been playing with NHibernate (especially Fluent NHibernate) for couple months. I really like it and appreciate people who contribute to those projects. I am trying to create an Oracle Text Index using NHibernate, but I couldn't get this to work. session.CreateSQLQuery("create index MYSCHEMA.NAME_TEXT_INDEX on MYSCHEMA...
In Oracle, the full text search syntax of Contains operator is: CONTAINS( [schema.]column, text_query VARCHAR2 [,label NUMBER]) RETURN NUMBER; which means the text_query can not be more than 4000 characters long or an error will occur. I repeatedly have text_query longer than 4000 characters lon...