求教

Question

select '123/323/343' from dual我现在想把  '123/323/343' 字段中的 “/” 找出来，并统计个数
求教相关SQL，谢谢！

Answer 1

select length('123/323/343')-length(REPLACE('123/323/343','/','')) "/的个数" from dual;

Answer 2

select length('123/323/343')-length(replace('123/323/343','/','')) geshu from dual;--GESHU
2

Answer 3

--来晚了点
SQL> edi
已写入 file afiedt.buf  1* select length('123/323/343')-length(replace('123/323/343' ,'/',''))  from dual
SQL> /LENGTH('123/323/343')-LENGTH(REPLACE('123/323/343','/',''))
-----------------------------------------------------------
                                                          2

Answer 4

select length('123/323/343')-length(replace('123/323/343' ,'/'))  from dual;

Answer 5

select length('123/323/343')-length(replace('123/323/343' ,'/')) from dual;貌似都是一个方法,