表中有个字段是varchar2,如
id content
1 "kankan,tingting,zzzz,"
2 "1234,zzzzzz,fffffffffffffff,ooo,zzzz,m,"我想查出content中含“,"的个数,返回如下结果id inumber
1 3
2 6
id content
1 "kankan,tingting,zzzz,"
2 "1234,zzzzzz,fffffffffffffff,ooo,zzzz,m,"我想查出content中含“,"的个数,返回如下结果id inumber
1 3
2 6
select id,yourfunc(content) from table;