0 Replies Latest reply on Aug 29, 2012 3:18 PM by skv

    Proximity Search Text


      I need help in Proximity search in Oracle Text.

      For example, below query gives all records that contains "Finance" and "Econony" within 10 words...

           SELECT col1_id, col2_text
           FROM table1
           WHERE CONTAINS (col2_text, 'NEAR ((finance, economy), 10)') > 0;

      I want to display 10 words before and 10 words after "finance/econony" words for each and every occurrance in all the records returned by above query.

      Can you please let me know how to achieve this. I am working on Oracle Database 11g Enterprise Edition Release

      Thanks a lot in advance.