how to count no of times a letter occurs in oracle

[rahulae]

im trying get the occurence of a particular letter and then depending on that result i have to find the name from table that has more than 1 occurence of particular letter

[amitpatel66]

occurance of particular letter from where?...I assume you want those column values which has occurance of particular letter n times??

n - occurance count of a particular letter

[rahulae]

for example there are three names in table

ADAMS
DAVE
SMITH

i should get the name that has two A's in it

[debasisdas]

you need to use string functions like SUBSTR,INSTR and LENGTH for the prpose.

[rajeshvakkala]

Hi,
can u explain with an example


Regards,
raj

[amitpatel66]

Try this:

[code=oracle]
SQL> select * from emp where address like '%A%A%';

EMPNO ADDRESS
---------- --------------------------------------------------------------------------------
10 ADAM
20 123 abc road, texas,USA - 123

SQL>
[/code]