SELECT SCORE(1), title 
FROM my_text_table
WHERE CONTAINS(textcol, '%hi%', 1) > 0;

SQL> CREATE TABLE my_text_table(
  2    id NUMBER PRIMARY KEY,
  3    title VARCHAR2(30),
  4    doc CLOB
  5  );

Table created.

SQL>
SQL> INSERT INTO my_text_table VALUES(1, 'doc1', 'Hi Sara, ...');

1 row created.

SQL> INSERT INTO my_text_table VALUES(2, 'doc2', 'Hi Hi Mam');

1 row created.

SQL> INSERT INTO my_text_table VALUES(3, 'doc3', 'A highly recommended document');

1 row created.

SQL> INSERT INTO my_text_table VALUES(4, 'doc4', 'Another document');

1 row created.

SQL>
SQL> CREATE INDEX my_text_index ON my_text_table(doc)
  2    INDEXTYPE IS ctxsys.context;

Index created.

SQL>
SQL> SELECT SCORE(1), title
  2    FROM my_text_table
  3   WHERE CONTAINS(doc, '%hi%', 1) > 0;

  SCORE(1) TITLE
---------- ------------------------------
         4 doc1
         8 doc2
         4 doc3