I'm fairly inexperienced with SQL so hopefully this question is not too silly. Here is the scenario:
I have a VARCHAR2 column that stores a series of values delimited by product. Depending on on the account, they can have one or multiple products. I'm trying to write a query that will return the values but also provide a count for each type or product.
ProductColumn: P1, P2, P3, P4 Table: TableAccount Sample Value 1: P1:P2:P3 Sample Value 2: P1 Sample Value 3: P2:P3
My current query only returns a count of all different value types including the delimited values:
select ProductColumn, count(8) cnt from TableAccount group by ProductColumn
Any suggestions would be appreciated!