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

Which version of sql do I have?

563


how to get a list of columns in an existing table? : Sql dba

544


How to start oracle sql developer?

558


How can we implement rollback or commit statement in a trigger?

581


What are the possible values that can be stored in a boolean data field?

517






Can a commit statement be executed as part of a trigger?

602


Which is faster truncate or drop?

561


What is sql rowcount?

559


What is meant by temporal data?

546


Why are aggregate functions called so?

516


What is sql*plus?

572


Can we use distinct and group by together?

588


What is difference between cursor and trigger?

559


how to include character strings in sql statements? : Sql dba

556


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

669