This discussion is archived
1 Reply Latest reply: Dec 26, 2012 8:41 AM by Jim Smith RSS

regexp_substr

947761 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points