How to find the count of letter "L" in HELLO

Answer Posted / a.brahmam

select length('HELLO')-length(replace('HELLO','L')) from dual;
ANS:=2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why stored procedure is faster than query?

601


What are the types of queries in sql?

626


What is the difference between a subquery and a join?

605


Why is %isopen always false for an implicit cursor?

674


What is before and after trigger?

610






What is cross join sql?

590


how to write date and time literals? : Sql dba

616


what is innodb? : Sql dba

672


Explain the difference in execution of triggers and stored procedures?

661


What is the use of pl/sql table?

653


Can you have a foreign key without a primary key?

589


What is the sql query to display the current date?

638


What is the difference between local and global temporary table?

649


What are all the different normalizations?

669


Why we use stored procedure instead of query?

617