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>
Date: Fri, 29 Aug 2003 05:49:44 -0400
Message-ID: <3302212.1062150584_at_dbforums.com>
</Digest>
i do:
- ctx_ddl.create_section_group('autogroup', 'AUTO_SECTION_GROUP');
- 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.comReceived on Fri Aug 29 2003 - 11:49:44 CEST