Multiple keywords searched dynamiccly
Hi All,
Having a problem here.
Suppose I have a table book with columns : ID, Title.
I have another table subject with columns :
ID, code, keywords.
1, Animals, Dog
2. Animals, Cat
3. Animals, Snake
4. Animals, Horse
5. Cars, BMW
6. Cars, Mercedes
7. Cars, Volkswagen
I want to full text query the book table title column with for example all animals (that are known in the subject table matching animals)
So the full text query should match against Dog or Snake or Cat or Horse.
So basiccly I want to look up in the subject table all the keywords that should be used in full text query?
(Ofcourse when the table is updated with 8. Animals, Cow, the fulltext query executed would be also with Cow next time.)
Am I making myself clear?
Please let me know if not,
Can anybody help me achieving this?
Subject
Views
Written By
Posted
Multiple keywords searched dynamiccly
3339
August 03, 2010 07:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.