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

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


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...?

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

Current Time: Fri Mar 24 10:44:09 CDT 2023