How to query using ABOUT operator in Oracle Text

Hi,

I have a requirement of searching the similar values (same meaning values) from a table column based on a text passing to the query. I know that the ABOUT operator in Oracle Text will be useful for it. But, I am not able to find a way to use it properly.

Here, is the approach, I have followed for this case:

Created a table VenuTest and inserted some data into it:

CREATE TABLE VenuTest(id NUMBER, text VARCHAR2(2000))

INSERT INTO venutest VALUES (1,'temperature');

INSERT INTO venutest VALUES (2,'house');

Created a Basic Lexer:

begin

  ctx_ddl.create_preference('mylex', 'BASIC_LEXER');