title: How to create text index for '%abc%' search?
body: <p>I'd like to index queries like <code>x like '%abc%'</code></p>
  
  <p>If I have a table like the following</p>
  
  <pre><code>create table t
  (
    data varchar(100)
  );
  </code></pre>
  
  <p>I want to create an index to be able to do the following efficiently:</p>
  
  <pre><code>select * from t where contains('%abc%');
  </code></pre>
  
  <p>And this:</p>
  
  <pre><code>select * from t where contains('abc%');
  </code></pre>
  
  <p>I also want this table to be updated live.</p>
  
  <p>How do I create such an index? (I have a feeling I need a <code>ctxcat</code> index, but I'm confused about what options I need to give it)</p>
  
  <p>I'm using Oracle 10g.</p>