Oracle Text quickstart demo

View All Scripts Login to Run Script

Statement 1

create table demo(id number primary key, text varchar2(200))

Table created.

Statement 2

insert into demo values (1, 'the quick brown fox jumps over the lazy dog')

1 row(s) inserted.

Statement 3

insert into demo values (2, 'the lazy fox jumps over the lazy dog')

1 row(s) inserted.

Statement 4

create index demoindex on demo(text) indextype is ctxsys.context

Index created.

Statement 5

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

2 rows selected.

TEXT	SCORE(99)
the lazy fox jumps over the lazy dog	6
the quick brown fox jumps over the lazy dog	3

Additional Information