New answers tagged

0

I think you can get what you need from the DMVs, including sys.dm_fts_index_keywords_by_document and sys.dm_fts_parser, something like this: SELECT p.phrase, kbd.display_term FROM sys.dm_fts_index_keywords_by_document( DB_ID(), OBJECT_ID('dbo.documentText') ) kbd CROSS APPLY dbo.phrases p CROSS APPLY sys.dm_fts_parser ( N'FORMSOF(FREETEXT, "' + ...


1

Try this: go create function dbo.fn_GetCountForPhrase (@phrase varchar(500)) returns int as begin declare @count int declare @localphrase varchar(8000) set @localphrase='"' + @phrase + '"' SELECT @count=COUNT(*) FROM table a WHERE CONTAINS(table.description, @localphrase) return @count end go SELECT phrase, dbo....


0

I want to share another alternative: Create a new column having the data of all columns used to find: ALTER TABLE employees ADD criterio varchar2(100); update employees set criterio = nickname || ' ' || name || ' ' || lastname; Create the index using the new column Oracle Text: create index employees_criterio on employees(criterio) indextype is ctxsys....


3

One method is to use the MULTI_COLUMN_DATASTORE. Below is an example: drop table t1 purge; create table t1 (column1 varchar2(100), column2 varchar2(100)); insert into t1 values ('HELLO', 'WORLD'); insert into t1 values ('SAY', 'HELLO'); insert into t1 values ('SOMETHING', 'ELSE'); insert into t1 values ('WORLD', 'CUP'); commit; Create the datastore with ...



Top 50 recent answers are included