Top "Oracle-text" questions

a tool for building text query applications and document classification applications on top of Oracle databases.

Does Oracle support full text search?

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

oracle full-text-search oracle-text
Oracle DBMS_LOB.INSTR and CONTAINS performance

Is there any performance difference between dbms_lob.instr and contains or am I doing something wrong? Here is my …

sql oracle oracle10g oracle-text
How to sync and optimize an Oracle Text index?

We want to use a ctxsys.context index type for full text search. But I was quite surprised, that an …

oracle full-text-search oracle-text
How to get around 4000 characters limitation of text_query in Oracle's CONTAINS operator?

In Oracle, the full text search syntax of Contains operator is: CONTAINS( [schema.]column, text_query VARCHAR2 [,label NUMBER]) RETURN …

oracle full-text-search oracle-text
Oracle: Full text search with condition

I've created an Oracle Text index like the following: create index my_idx on my_table (text) indextype is ctxsys.…

sql oracle indexing full-text-indexing oracle-text
CONTAINS doesn't work with Oracle Text

I am having an issue executing this query. SELECT * FROM gob_attachment WHERE CONTAINS (gob_a_document, 'java') > 0 It's …

sql oracle oracle-sqldeveloper oracle-text
Set up Oracle Text to index values of multiple columns in Oracle tables

I have a set of Oracle tables that describe information about property owners. Owner names and other text values are …

oracle indexing oracle-text