tag:blogger.com,1999:blog-8873109125023142810.post4942341874808767428..comments2024-03-29T13:16:28.902+05:30Comments on Let's Develop in Oracle: Oracle: Comma Separated String To RowsNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8873109125023142810.post-64761653205955605962014-07-24T00:08:34.145+05:302014-07-24T00:08:34.145+05:30Thanks Ashish. You saved my day. Thanks Ashish. You saved my day. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-73578998260756597952012-05-14T13:18:14.343+05:302012-05-14T13:18:14.343+05:30yes, regexp_count(txt,'[,]+')+1 and length...yes, regexp_count(txt,'[,]+')+1 and length (txt) - length (replace (txt, ',')) + 1 both have same resultNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-60945319361378659892012-03-15T16:01:50.914+05:302012-03-15T16:01:50.914+05:30We can also use:
select
regexp_substr (txt, ...We can also use:<br /> <br />select <br />regexp_substr (txt, '[^,]+', 1,level) data <br />from t <br />CONNECT BY level <= regexp_count(txt,'[,]+')+1Ashishhttps://www.blogger.com/profile/11596187843485584679noreply@blogger.com