Answer the question
In order to leave comments, you need to log in
How to use Russian morphology in Oracle Text (in DBMS 11g R2)?
Hello colleagues.
The official documentation for Oracle Text 11 g Release 2 (11.2) ( link ) says that Russian morphology is supported at the word stem level (stemmer). Tried this in practice:
Table:
select * from docs;
ID TEXT
---------- --------------------
1 читать
2 читаю
3 читал
4 чтение
5 sing
6 sang
7 singing
8 sung
exec ctx_ddl.create_preference('MYLEXER', 'world_lexer');
create index i_docs on docs (text) indextype is ctxsys.context
parameters ('LEXER MYLEXER stoplist CTXSYS.EMPTY_STOPLIST');
SELECT SCORE ( 1 ), text
FROM docs
WHERE CONTAINS (text, '$sing', 1 ) > 0
ORDER BY SCORE ( 1 ) DESC;
SELECT SCORE ( 1 ), text
FROM docs
WHERE CONTAINS (text, '$читать', 1 ) > 0
ORDER BY SCORE ( 1 ) DESC;
NLS_CHARACTERSET CL8ISO8859P5
NLS_NCHAR_CHARACTERSET AL16UTF16
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question