InStr and SUBSTR usage in Oracle ____oracle

  --  INSTR (source string, the string to find, starting with the first few characters, to find the ordinal number of matches) if it is not found, return 0. A bit like the Get array subscript
            Select INSTR in Java (' Ni ... HA,.OWCAO,NIA,.M,.. , Bi ', ', ', 3, 2) from dual
---------------------------------------                                 14

  --substr (' String to intercept ', target position, target position to intercept several)  similar to subString select Substr in Java
          (' W ai ni ni ', 4, 2) from dual
--------------------------------------------------in