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

What is the benefit of foreign key?

960

What is a unique key and primary key and foreign key?

917

Is it possible to pass parameters to triggers?

1029

What is sql select statement?

968

how would you get the current date in mysql? : Sql dba

911

Can we change the table name in sql?

887

How do you pronounce sql?

954

What is acid property in a database?

973

What is a ddl command?

1005

Why use triggers in sql?

892

What is the difference between inner join and natural join?

953

What is the size of partition table?

989

What is the most restrictive isolation level? : Transact sql

1022

Are subqueries better than joins?

916

Explain what is a view?

997