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

Can sql function call stored procedure?

1025

Why do we use sql constraints?

1171

Which join condition can be specified using on clause?

952

What are different types of sql?

1191

Why cross join is used?

1077

How many types of indexes are there in sql?

985

Explain what is a view?

1060

Differentiate pl/sql and sql?

1070

what's the difference between a primary key and a unique key? : Sql dba

1050

What is secondary key?

934

What is bulk compiling in pl/sql.?

1130

how can we know the count/number of elements of an array? : Sql dba

1061

How does sql developer connect to oracle database?

1004

What is primary key and foreign key?

962

What is server name sql?

1147