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

Dimon wrote:
> 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

You use a ConText search; use a regular instead: select xml_field from revision where xml_field = 'Par';

-- 
Regards, Frank van Bortel