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:

Expand|Select|Wrap|Line Numbers

 
SQL> select * from emp where address like '%A%A%';
 
     EMPNO ADDRESS

---------- --------------------------------------------------------------------------------

        10 ADAM

        20 123 abc road, texas,USA - 123
 
SQL>

how to count no of times a letter occurs in oracle

re: how to count no of times a letter occurs in oracle

re: how to count no of times a letter occurs in oracle

re: how to count no of times a letter occurs in oracle

re: how to count no of times a letter occurs in oracle

re: how to count no of times a letter occurs in oracle

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about