Help me!!! Search XML Data with Oracl Text...

From: Dimon <member37389_at_dbforums.com>
Date: Fri, 29 Aug 2003 05:49:44 -0400
Message-ID: <3302212.1062150584_at_dbforums.com>


Hi! how me do this task :

i have table with field containts XML data, for example :

<Digest>

<p i="1" e="0">

<name>Non Edit</name>

<value>Non Edit Par</value>

</p>

<p i="2" e="1">

<name>Edit</name>

<value>Edited Par</value>

</p>

<p i="3" e="2">

<name>Mandatory</name>

<value>Mandatory Par</value>

</p>

</Digest>

i do:

  1. ctx_ddl.create_section_group('autogroup', 'AUTO_SECTION_GROUP');
  2. create index revision_index on revision (attributes_xml) indextype is ctxsys.context parameters ('filter ctxsys.null_filter section group autogroup');

and now i want select records with "Par" in <value>, and i do:

select xml_field from revision where contains (xml_field, '"Par" within value') > 0;

i get records with "Par", "Mandatory Par" and "Edited Par" in tag
<value>, but i want get "Par" only!!! i don't want effect type of Like,
i want search exact.

help me please... any idea ? ....

--
Posted via http://dbforums.com
Received on Fri Aug 29 2003 - 11:49:44 CEST

Original text of this message