This discussion is archived
8 Replies Latest reply: Oct 22, 2013 10:38 AM by 878475 RSS

Contains/Beginswith Text Searchi in XMLTYPE

user8367258 Newbie
Currently Being Moderated

Hi,

 

This is the XML doc i have,

 

<Node>

      <id>Name</id>

      <Node1>

        <value>

          <response>Raja</response>

        </value>

      </Node1>

</Node>

 

I want to do name search with Contains() or BeginsWith(), Oracle text search,  I m not to figure out the steps to create index for these kind of XML nodes.  Can some one help me out on this?

 

It would be great help if you guys explain me with some example since i am new to OracleXML DB.

 

Thanks

KR

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points