Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

split a string and count

555898May 16 2007 — edited May 17 2007
Hi

I need to split one columns data ( which is a varcha2 string seperated by a colon)
and then list the data individually allong with a count of its instances.

ID data
1 E2121:B2121:R5421
2 E2121:B2121:R5421E:2121

From this I want

Data Count
E2121 3
B2121 2
R5421 2

There can be varied number of items in the data column (somtimes no data) and i can do this sql or plsql

thanks peoples
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2007
Added on May 16 2007
22 comments
2,368 views