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

How many tables can you join in sql?

898

How many sql databases can you have on one server?

1016

what is the difference between where clause and having clause? : Sql dba

947

Explain the components of sql?

992

Is json a nosql?

914

Do ddl statements need commit?

921

how to calculate expressions with sql statements? : Sql dba

979

What is the difference between nvl function, ifnull function, and isnull function?

1049

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

915

Why do we use joins?

983

Can we join more than 2 tables in sql?

945

what is the use of double ampersand (&&) in sql queries?

1114

What is nosql db?

923

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

928

What is pl sql variable?

933