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

Access Camera HTML 5

Access camera and video, the  INPUT  element with a type of  file  is necessary: < input type = " file " accept = " i...

buy cloth