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

explain the difference between bool, tinyint and bit. : Sql dba

520

What is interval partition?

539

what is the difference between group by and order by in sql? : Sql dba

596

Explain raise_application_error.

640

what are the 'mysql' command line arguments? : Sql dba

644

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

522

Is sql dba a good career? : SQL DBA

527

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

618

What is use of trigger?

508

how to use 'mysql' to run sql statements? : Sql dba

537

What is character functions?

552

What are the set operators in sql?

547

Which is better varchar or nvarchar?

544

How many sql statements are used?

562

Is sqlite thread safe?

598