create table demo(id number primary key, text varchar2(200))
Table created.
insert into demo values (1, 'the quick brown fox jumps over the lazy dog')
1 row(s) inserted.
insert into demo values (2, 'the lazy fox jumps over the lazy dog')
1 row(s) inserted.
create index demoindex on demo(text) indextype is ctxsys.context
Index created.
select text, score(99) from demo where contains(text, 'lazy', 99) > 0 order by score(99) desc
| TEXT | SCORE(99) | the lazy fox jumps over the lazy dog | 6 | the quick brown fox jumps over the lazy dog | 3 |
|---|