title: How to create an Inverted Index on a table using Oracle
body: <p>I have a table called book with columns ISBN, Title and Description.  I have been trying to create an inverted index on this table using the command:</p>
  
  <pre><code>CREATE INDEX myindex ON book(description) INDEXTYPE IS CTXSYS.CONTEXT;
  </code></pre>
  
  <p>and I've been trying to query it with the query below:</p>
  
  <pre><code>  SELECT score(1), title 
      FROM book b
     WHERE CONTAINS(b.description, 'Huckleberry Finn', 1) &gt; 0 
  ORDER BY score(1) DESC;
  </code></pre>
  
  <p>Whenever I run this query, however no rows are selected even though the query</p>
  
  <pre><code>SELECT title, description
    FROM book
   WHERE description = 'Huckleberry Finn';
  </code></pre>
  
  <p>returns:</p>
  
  <pre><code>Title          description
  ------------------------------------
  'Huckleberry'  'Huckleberry Finn'
  </code></pre>
  
  <p>I am not sure what is wrong with my queries, this is the first time I've ever tried to create an inverted index, so if anyone could tell me either what is wrong with my query or another way to do this, I would really appreciate it.</p>