Home » Server Options » Text & interMedia » Oracle Text with INPATH
Oracle Text with INPATH [message #419871] Tue, 25 August 2009 16:59
anu_sat2004@yahoo.com
Messages: 1
Registered: August 2009
Junior Member
Hi,

I have a table with a CLOB coloumn. This coloumn stores XML documents. This is the structure of my XML Document.

<Record>
<Answers>
<RuleAnswers>
<RuleAnswer>
<Rule_ID>101</Rule_ID>
<Answer>N</Answer>
</RuleAnswer>
<RuleAnswer>
<Rule_ID>101<Rule_ID>
<Answer>Y</Answer>
</RuleAnswer>
</RuleAnswers>
</Answers>
</Record>

Now i want to fetch those records which has 'N' in the <Answer> tag for <Rule_ID> 101. I tried with the contains clause and INPATH in oracle. But that always checks wehther a given value is there in the specified node. I hope the contains doesn't work for this case. Anybody have an idea how to do this...?

REgards,
Anu
Previous Topic: CTXCAT indexes while migrating to Oracle 11g
Next Topic: Synchronization of context index
Goto Forum:
  


Current Time: Thu Mar 28 21:15:43 CDT 2024