Oracle Text and searches across columns

From: Jake <>
Date: Sun, 3 Feb 2008 12:34:05 -0800 (PST)
Message-ID: <>

Say if I am making a database of college classes across many colleges, where people can search and find classes.

So, for example, each class has a:

level - bachelors, graduate (for example) college name- State U, or SU as short name, along with other colleges semester - Fall 2008...
Category - Biology, Math, Music etc.
course number - BIO 101
description - a full text description of the course. etc.

as you can imagine, all of these things are in many tables in many columns. The "full description" that the user sees actually contains information from a join of many columns.

What I would like is for the user to be able to search given a text phrase, and given a list of hits from all classes where the "full description" contains every one of the words they search for. The words do not have to be in any particular order. Example searches: "Biology 101" "BIO 101" "SU Math Fall 2008"

I haven't seen an Oracle Text example that handles this type of case.

What is the best way to do this? Can any one point me in the right direction? Received on Sun Feb 03 2008 - 14:34:05 CST

Original text of this message