title: Unable to pull the results by passing input as xml path in oracle
body: <p>I am just trying to pull the records bypassing the XML path in where the condition of SQL unfortunately I am unable to do.</p>
  <p><strong>Note</strong>: Pull the records bypassing input as salesteamid value. Please someone can help me to run the query without any failures.</p>
  <p><strong>Query</strong> :</p>
  <pre><code>SELECT * from activity where= ExtractValue('/ActivityId/Agent/Territory/SalesTeamId[contains(10669)]');
  </code></pre>
  <p><strong>XML</strong>:</p>
  <pre><code>&lt;Activity
      xmlns=&quot;urn:astrazeneca:na:Activity:domain:3&quot; RestrictionGroup=&quot;NONE&quot;
      xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot; xsi:type=&quot;DiscussionActivityType&quot; TransactionCode=&quot;I&quot; CreatedOnDate=&quot;2019-11-21T16:04:29&quot; UpdatedOnDate=&quot;2019-11-21T16:04:32&quot; SourceCreatedByID=&quot;20303090&quot; SourceCreatedByFirstName=&quot;Brandy&quot; SourceCreatedByLastName=&quot;Nirider&quot; SourceCreatedByRole=&quot;&quot; SourceUpdatedByID=&quot;20303090&quot; SourceUpdatedByFirstName=&quot;Brandy&quot; SourceUpdatedByLastName=&quot;Nirider&quot; SourceSystemCode=&quot;FSA&quot; SystemOfRecordCode=&quot;FSA&quot; RecordCompanyCode=&quot;AZN&quot; SourceCountry=&quot;USA&quot; SourceRegion=&quot;USA&quot; SourceSystemGroup=&quot;VNA&quot; SystemOfRecordGroup=&quot;VNA&quot;&gt;
      &lt;ActivityId&gt;
          &lt;ns2:ID
              xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot; SystemCode=&quot;VNA&quot;&gt;a080P00001YZM7WQAX
          &lt;/ns2:ID&gt;
      &lt;/ActivityId&gt;
      &lt;Agent&gt;
          &lt;EmployeeId&gt;
              &lt;ns2:ID
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot; SystemCode=&quot;EMPLID&quot;&gt;20303090
              &lt;/ns2:ID&gt;
          &lt;/EmployeeId&gt;
          &lt;Territory&gt;
              &lt;ns2:TerritoryId
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot;&gt;
                  &lt;ns2:ID SystemCode=&quot;AZ&quot;&gt;20070009&lt;/ns2:ID&gt;
              &lt;/ns2:TerritoryId&gt;
              &lt;ns2:TerritoryCode
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot;&gt;20070009
              &lt;/ns2:TerritoryCode&gt;
              &lt;ns2:Role
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot;&gt;PSS
              &lt;/ns2:Role&gt;
              &lt;ns2:Description
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot;&gt;Indianapolis C IN 2
              &lt;/ns2:Description&gt;
              &lt;ns2:SalesTeamId
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot;&gt;
                  &lt;ns2:ID SystemCode=&quot;AZ&quot;&gt;10669&lt;/ns2:ID&gt;
              &lt;/ns2:SalesTeamId&gt;
              &lt;ns2:SalesTeamCode
                  xmlns:ns2=&quot;urn:astrazeneca:na:CommonTypes:domain:2&quot;&gt;D_ALPHA
              &lt;/ns2:SalesTeamCode&gt;
          &lt;/Territory&gt;
      &lt;/Agent&gt;
      &lt;Customer&gt;
          &lt;AZCustomerMasterID SystemCode=&quot;AZ&quot;&gt;58586509&lt;/AZCustomerMasterID&gt;
          &lt;SourceCustomerID SystemCode=&quot;NAVVA&quot;&gt;001U000000pMTySIAW&lt;/SourceCustomerID&gt;
          &lt;CustomerType&gt;HCP&lt;/CustomerType&gt;
          &lt;CustomerActivityRole&gt;participant&lt;/CustomerActivityRole&gt;
      &lt;/Customer&gt;
      &lt;ReferenceContent&gt;
          &lt;ReferenceName&gt;Reported Adverse Reaction&lt;/ReferenceName&gt;
          &lt;ReferenceType&gt;action&lt;/ReferenceType&gt;
          &lt;ReferenceId SystemCode=&quot;VNA&quot;&gt;Reported Adverse Reaction&lt;/ReferenceId&gt;
      &lt;/ReferenceContent&gt;
      &lt;StartDate&gt;2019-11-21T16:03:00&lt;/StartDate&gt;
      &lt;EndDate&gt;2019-11-21T16:03:00&lt;/EndDate&gt;
      &lt;Topic&gt;
          &lt;Name&gt;BYDUREON BCISE&lt;/Name&gt;
          &lt;Product&gt;
              &lt;AZBrandId SystemCode=&quot;AZ&quot;&gt;881574&lt;/AZBrandId&gt;
              &lt;AZProductId SystemCode=&quot;AZ&quot;&gt;881574&lt;/AZProductId&gt;
              &lt;SourceProductId SystemCode=&quot;&quot;/&gt;
              &lt;ReferenceProductId SystemCode=&quot;&quot;/&gt;
              &lt;ProductName&gt;BYDUREON BCISE&lt;/ProductName&gt;
          &lt;/Product&gt;
      &lt;/Topic&gt;
      &lt;ActivityAction&gt;discussion&lt;/ActivityAction&gt;
      &lt;ActivityStatus&gt;completed&lt;/ActivityStatus&gt;
      &lt;ActivityInitiatedBy&gt;AstraZeneca agent&lt;/ActivityInitiatedBy&gt;
      &lt;ActivityOutcome&gt;success with identified customer&lt;/ActivityOutcome&gt;
      &lt;CommunicationMode&gt;in person&lt;/CommunicationMode&gt;
      &lt;LocationSetting&gt;Selling&lt;/LocationSetting&gt;
      &lt;SourceValues&gt;
          &lt;Status&gt;Submitted&lt;/Status&gt;
          &lt;SubStatus&gt;Completed&lt;/SubStatus&gt;
          &lt;Applet&gt;Actions&lt;/Applet&gt;
          &lt;Activity&gt;Detail Only&lt;/Activity&gt;
          &lt;InteractionCategory&gt;A_Selling (PSS)&lt;/InteractionCategory&gt;
          &lt;Type&gt;Selling&lt;/Type&gt;
      &lt;/SourceValues&gt;
      &lt;Priority&gt;2&lt;/Priority&gt;
      &lt;DiscussionTool&gt;N&lt;/DiscussionTool&gt;
      &lt;ActivityTypeCheck&gt;DiscussionActivityType&lt;/ActivityTypeCheck&gt;
  &lt;/Activity&gt;
  </code></pre>