SQLTIP－－文字列から単語の数を計算

SELECT
(LENGTH ('THIS IS TEST STRING')
- LENGTH (REPLACE ('THIS IS TEST STRING', 'IS'))
)
　　　 / LENGTH ('IS') cnt
FROM DUAL
/