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

Answer Posted / ansupriya

SELECT LENGTH(REPLACE(TRANSLATE('HELLO','HEO',' '),' ')) FROM DUAL

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql considered coding?

566


Is vs as in pl sql?

487


what is uncommittable transactions? : Transact sql

558


What is database migration?

513


How do I install sql?

516






What is compiled query?

513


What are types of exception?

530


What is a data manipulation language?

568


What is pl sql collection?

514


How sql query is executed?

548


What types of commands can be executed in sql*plus?

542


how to use like conditions? : Sql dba

568


What is an inner join sql?

540


What is parallel hint?

742


What is view explain with example?

514