How do I count the number of words or words in the varchar field

zhanglei39

One field in the table is varchar2, such as
id content
1 "kankan, tingting, zzzz,"
2 "1234, zzzzzz, fffffffffffffff, ooo, zzzz, m,"

I want to find out the number of "," in the content and return the following result

id inumber
1 3
2 6

tiger_mars

Write a function to return a string, the number of
select id, yourfunc (content) from table;