Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    14

    Unanswered: synonym query in oracle

    Hi there,
    I have defined a synonym group of words using Intermedia.
    The query I am using at the moment is:
    select * from textsyn where contains(description, 'about(the_search_word)')>0

    Any ideas how can I query synonyms without losing the generality that offers me the "about" term instead of creating the following query:
    select * from textsyn where contains(description, 'syn(the_search_word)')>0

    Regards,
    Kostas.

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Kostas,

    Are you trying to find something like this:

    ... CONTAINS( description, 'SYN( ABOUT( the_search_word ) )' ) > 0

    I've not tried this myself since I've not defined a synonym group, but you might and see if you get the desired result.
    JoeB
    save disk space, use smaller fonts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •