4 Replies Latest reply on Jul 24, 2014 6:54 AM by Marwim

    Need help in regexp

    User608206

      I am trying to run query in oarcle apps and wanted to select rows, which meets multiple org code seprated by , and my input value is like 127,123 , it will convert into ('127','123') this regexp 

       

      select * from ORG_ORGANIZATION_DEFINITIONS  where organization_code IN (select '('||regexp_replace(regexp_replace(regexp_replace(:p_inv_org_code, '( )+',','),',',''','''),'^|$','''')||')' from dual)

       

      ---naresh