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 is a dirty read sql?

1108

Explain the methods used to protect source code of pl/sql.

1006

what are date and time intervals? : Sql dba

1034

What is percent sign in sql?

1265

Is nosql faster than sql?

1000

what are the advantages of mysql in comparison to oracle? : Sql dba

987

What are analytic functions in sql?

1007

What are all the different normalization?

1024

how to create a table index in mysql? : Sql dba

1035

What is a sql instance vs database?

1100

What are the different types of constraints?

1154

Which join is like inner join?

1005

What is cursor explain with example?

964

What is the difference between rename and alias?

1325

how to extract a unit value from a date and time? : Sql dba

978