select length('HELLO')-length(replace('HELLO','L&#

How to find the count of letter "L" in HELLO

Question Posted / a.brahmam

Answer Posted / a.brahmam

select length('HELLO')-length(replace('HELLO','L')) from dual;
ANS:=2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are crud methods?

1087

What is procedure and function?

1035

What is a heap in sql?

1149

Can variables be used in sql statements?

1075

What are the string functions in sql?

1024

Can one improve the performance of sql*loader? : aql loader

1099

what is sql in mysql? : Sql dba

1238

What can sql server reporting services do?

1166

what is the difference between blob and text? : Sql dba

1064

What is sap sql anywhere?

1169

what happens if you no create privilege in a database? : Sql dba

1050

How to make a copy values from one column to another in sql?

1084

What are analytic functions in sql?

1074

What is fmtonly in sql?

1165

How does left join work in sql?

1041