OraFAQ Forum: Text & interMedia » Oracle Text with INPATH

Home » Server Options » Text & interMedia » Oracle Text with INPATH

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	CTXCAT indexes while migrating to Oracle 11g
Next Topic:	Synchronization of context index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 23:34:10 CST 2025