0 Replies Latest reply: Apr 17, 2014 8:24 AM by user4423142 RSS

    ora:contains

    user4423142

      Hi everybody

       

      Oracle used : 11g Release 11.2.0.3.0

       

      Here a request on a relationnal table  :

      select * from XMLTable('for $i in fn:collection("oradb:/FMTRP/USERS")

      where ora:contains($iROW/USER_NAME,"L")>0 return $i/ROW/USER_NAME/text()');

      Result :

      L.EYMARDIER

      L.FRERETO

      PACALEY L. Just begin by L or end by L

      but not C.BELLERI for example. Why ?

       

      select * from XMLTable('for $i in fn:collection("oradb:/FMTRP/USERS")

      where ora:contains($iROW/USER_NAME,"Y")>0 return $i/ROW/USER_NAME/text()');

      does not return L.EYMARDIER.

       

      Another question. I made some test with the function inPlaceEvolve. It works but the documentation says that it is possible to set up the last parameter to 2 to make a dry run. So we can check if all is OK but the modification are not applied. How can we check that, what is the trace file ?

       

      Regards

      Thanks in advance