SELECT LENGTH(REPLACE(TRANSLATE('HELLO','HEO',' &#

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

Question Posted / ansupriya

Answer Posted / ansupriya

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Enlist the data types that can be used in pl/sql?

651

What is sql engine in oracle?

621

What is a table in a database?

665

what are the non-standard sql commands supported by 'mysql'? : Sql dba

664

What packages(if any) has oracle provided for use by developers?

5153

What is the use of procedures?

647

What is database migration?

604

Can a view be mutating? If yes, then how?

668

How to connect a sql*plus session to an oracle server?

728

How do I add a database to sql?

673

Which are the different case manipulation functions in sql?

626

What is java sql connection?

601

Explain select statements in sql?

686

What are the basic sql commands?

637

What is the difference between syntax error and runtime error?

694