SCOTT@orcl_11g> ALTER TABLE emp ADD (any_column VARCHAR2 (1))
  2  /

Table altered.

SCOTT@orcl_11g> BEGIN
  2    CTX_DDL.CREATE_PREFERENCE ('your_multi', 'MULTI_COLUMN_DATASTORE');
  3    CTX_DDL.SET_ATTRIBUTE ('your_multi', 'columns', 'ename, sal, empno, job, mgr');
  4  END;
  5  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11g> CREATE INDEX your_index ON emp (any_column)
  2  INDEXTYPE IS CTXSYS.CONTEXT
  3  PARAMETERS ('DATASTORE your_multi')
  4  /

Index created.

SCOTT@orcl_11g> SELECT empno, ename, sal, job, mgr FROM emp WHERE  CONTAINS (any_column, 'JONES') > 0
  2  /

     EMPNO ENAME             SAL JOB              MGR
---------- ---------- ---------- --------- ----------
      7566 JONES            2975 MANAGER         7839

SCOTT@orcl_11g> SELECT empno, ename, sal, job, mgr FROM emp WHERE  CONTAINS (any_column, 'CLERK') > 0
  2  /

     EMPNO ENAME             SAL JOB              MGR
---------- ---------- ---------- --------- ----------
      7369 SMITH             800 CLERK           7902
      7876 ADAMS            1100 CLERK           7788
      7900 JAMES             950 CLERK           7698
      7934 MILLER           1300 CLERK           7782

SCOTT@orcl_11g> SELECT empno, ename, sal, job, mgr FROM emp WHERE  CONTAINS (any_column, '7902') > 0
  2  /

     EMPNO ENAME             SAL JOB              MGR
---------- ---------- ---------- --------- ----------
      7369 SMITH             800 CLERK           7902
      7902 FORD             3000 ANALYST         7566

SCOTT@orcl_11g>