CREATE TABLE tz_docs
( doc_id NUMBER
( #cc66cc;">10 ), vc2doc VARCHAR2
( #cc66cc;">4000 ) ); INSERT INTO tz_docs VALUES
( #cc66cc;">1, 'Mary had a little lamb' );INSERT INTO tz_docs VALUES
( #cc66cc;">2, 'Twinkle, twinkle little star' );INSERT INTO tz_docs VALUES
( #cc66cc;">3, 'This Lamb is my lamb' );CREATE INDEX docs_vc2doc_idx ON tz_docs (vc2doc) INDEXTYPE IS ctxsys.context;
SELECT * FROM tz_docs;
SELECT * FROM tz_docs WHERE CONTAINS ( vc2doc, 'LaMb' );
SELECT CONTAINS
( vc2doc
, 'MARY AND LAMB' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'MaRy AnD lAmB' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, '%le' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'lamb NOT mary' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'NEAR ((lamb, mary) ,3)' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'NEAR ((lamb, mary) ,2)' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'mary ACCUM lamb' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'mary ACCUM little' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'mary ACCUM little lamb' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;SELECT CONTAINS
( vc2doc
, 'lamb OR little' ) #b1b100;">AS score1
, vc2doc FROM tz_docs
;