Re: Looking for a SQL Function

> Is there an Oracle character function returning the number of occurances
> of a substring in a string? INSTR() is close but not quite what I am
> looking for.

SELECT (LENGTH('abcdefabc') - LENGTH(REPLACE('abcdefabc','abc'))) / LENGTH('abc')
FROM dual;

hth

Ralf Received on Wed Nov 02 2005 - 00:59:18 CST