5 Replies Latest reply: Feb 11, 2013 3:12 AM by Senthilkumar S RSS

    Remove singloe quotes

    Senthilkumar S
      Hi,

      Am getting input parameter varchar2 as '1,2,3,4,5,65,6,7,8' to procedure.


      I want to remove single quotes and input to where for query.
      select * from  t1 where  col1 in  (1,2,3,4,5,65,6,7,8);
      here col1 is number data type

      Edited by: 925896 on Feb 10, 2013 10:47 PM