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 can I use instead of union in sql?

518

What is function and procedure?

568

How does one use sql*loader to load images, sound clips and documents? : aql loader

674

What is having clause in sql?

529

What is the purpose of normalization?

536

is it possible to pass an object or table to a procedure as an argument?

575

What is primary and foreign key?

593

What is sqlite used for?

532

Can you call pl/sql package functions from within a fast formula?

564

How can we make an if statement within a select statement?

543

What is program debugging?

566

Explain the uses of control file.

617

How to fix oracle error ora-00942: table or view does not exist

569

what is the different between now() and current_date()? : Sql dba

526

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

560