Oracle Text работа с контекстными индексами

  1. CREATE TABLE tz_docs ( doc_id NUMBER ( #cc66cc;">10 ), vc2doc VARCHAR2 ( #cc66cc;">4000 ) );
  2. INSERT INTO tz_docs VALUES ( #cc66cc;">1, 'Mary had a little lamb' );
  3. INSERT INTO tz_docs VALUES ( #cc66cc;">2, 'Twinkle, twinkle little star' );
  4. INSERT INTO tz_docs VALUES ( #cc66cc;">3, 'This Lamb is my lamb' );
  5. CREATE INDEX docs_vc2doc_idx ON tz_docs (vc2doc) INDEXTYPE IS ctxsys.context;
  6. SELECT * FROM tz_docs;
  7. SELECT * FROM tz_docs WHERE CONTAINS ( vc2doc, 'LaMb' );
  8. SELECT CONTAINS ( vc2doc, 'MARY AND LAMB' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  9. SELECT CONTAINS ( vc2doc, 'MaRy AnD lAmB' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  10. SELECT CONTAINS ( vc2doc, '%le' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  11. SELECT CONTAINS ( vc2doc, 'lamb NOT mary' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  12. SELECT CONTAINS ( vc2doc, 'NEAR ((lamb, mary) ,3)' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  13. SELECT CONTAINS ( vc2doc, 'NEAR ((lamb, mary) ,2)' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  14. SELECT CONTAINS ( vc2doc, 'mary ACCUM lamb' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  15. SELECT CONTAINS ( vc2doc, 'mary ACCUM little' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  16. SELECT CONTAINS ( vc2doc, 'mary ACCUM little lamb' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  17. SELECT CONTAINS ( vc2doc, 'lamb OR little' ) #b1b100;">AS score1 , vc2doc FROM tz_docs;
  18.  
Источники
https://www.interface.ru/home.asp?artId=5679 https://askdev.ru/q/kak-sinhronizirovat-i-optimizirovat-tekstovyy-indeks-oracle-386292/
14:20
705
Нет комментариев. Ваш будет первым!
Используя этот сайт, вы соглашаетесь с тем, что мы используем файлы cookie.