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 …

Read More
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 …

Read More
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 …

Read More
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 …

Read More
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.…

Read More
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 …

Read More
sql oracle oracle-sqldeveloper oracle-text