title: Index multiple columns of the same table for Context Full-Text Search?
body: <p>I have a table with 3 columns that need to be enabled for full-text searching via Oracle APEX Application. How can I create an index for all three columns so that they can all be searched?</p>
  
  <p>Currently I have context indexing on one column (STOP_NAME):</p>
  
  <pre><code>DECLARE
  
    l_query VARCHAR2(4000);
  
  BEGIN
  
    l_query:= 
     'select 
      "BUS_STOP_ID",
      "STOP_NAME",
      "DESC_NOTES",
      "BUS_NUMBERS",
      "LOCATION"
      from   "BUS_STOPS" ';
  
    IF v('P2_REPORT_SEARCH') IS NOT NULL THEN
      l_query := l_query||' '||'
      where 
      (   
       CONTAINS(STOP_NAME, ''$'|| v('P2_REPORT_SEARCH') ||''') &gt; 0
      )
     ';
    END IF;
  
    RETURN l_query;
  
  END;
  </code></pre>
  
  <p>But how can I create an index that uses three columns (stop_name, desc_notes, bus_numbers) for the text search? I tried using standard index creating using 3 columns but it didn't work:</p>
  
  <pre><code>CREATE INDEX bus_stops_ctx_idx
  ON bus_stops (stop_name, bus_numbers, desc_notes)
  INDEXTYPE IS ctxsys.context;
  </code></pre>