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 the use of sql trace?

464

How to run pl/sql statements in sql*plus?

580

What are user defined functions?

568

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

540

What is the difference between partitioning and sharding?

517

What is primary key sql?

525

Is merge a dml statement?

508

What is function and procedure?

554

What is procedure function?

522

Do we need to rebuild index after truncate?

514

what are all different types of collation sensitivity? : Sql dba

512

What is the difference between cluster and non-cluster index?

602

How to display the current date in sql?

585

Is mariadb a nosql database?

527

Can a composite key be null?

513