Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Unanswered: Oracle Text Search on Multiple columns and Tables

    Hello,
    I have a question regarding Oracle Text Search. Hoping someone can help me with it.
    I have a database that consists of 7 tables and have around 50 fields spread across the tables. I want to look for the search term in all the fields for a possible match.

    Is it possible to do something like that with Oracle Text, if yes can you direct me to some guide where I can look for this specific topic, because I had spent quite a bit of time searching on otn website but not much luck.

    Any help will be very much appreciated.
    Thanks
    Murtaza

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    why not write some dynamic sql?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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