1 Reply Latest reply: Dec 26, 2012 10:41 AM by Jim Smith RSS

    regexp_substr

    947761
      hi..i have the following sql

      select regexp_substr (:b_abcd,'[^,]+', 1, level)
      from dual Connect By
      regexp_substr(:b_abcd, '[^,]+', 1, level)
      Is Not Null

      when i pass values to bvar like 1,2
      the ouput is
      1
      2

      how can i get the Output like
      1,2