8 Replies Latest reply: Oct 22, 2013 12:38 PM by 878475 RSS

    Contains/Beginswith Text Searchi in XMLTYPE

    KRajaram

      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