select * from dual where contains(DUMMY,'X')>0
                         *
ERROR at line 1:
ORA-00904: "CONTAINS": invalid identifier

Select * from zrepository where fname like  '%.rar' and
updt_tms between to_date('02/21/2009', 'MM/DD/YYYY') and to_date('02/27/2009', 'MM/DD/YYYY')

SELECT *
  FROM DUAL
 WHERE contains (dummy, 'X') > 0

ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

SELECT *
  FROM scott.emp
 WHERE contains (empno, 7) > 0

CREATE TABLE accumtbl
   (ID NUMBER, text VARCHAR2(4000) );

INSERT INTO accumtbl
     VALUES (1,
             'the little dog played with the big dog 
      while the other dog ate the dog food');
INSERT INTO accumtbl
     VALUES (2, 'the cat played with the dog');

CREATE INDEX
   accumtbl_idx ON accumtbl (text)
   INDEXTYPE IS ctxsys.CONTEXT;


SELECT score (10)
  FROM accumtbl
 WHERE contains (text, 'dog ACCUM cat', 10) > 0;