Friday, October 17, 2014

comma separated values in oracle sql

Oracle coma Spited value Using regular Expression
select regexp_substr('1,2,3,4,'[^,]+', 1, level) as name from  dual
connect by regexp_substr('1,2,3,4, '[^,]+', 1, level) is not null

No comments:

Post a Comment

http://blogsiteslist.com