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

Is sql dba a good career? : SQL DBA

989

What is sqlite format?

1193

List different type of expressions with the example.

935

how would concatenate strings in mysql? : Sql dba

1093

How much does a sql dba make? : SQL DBA

941

What is the difference between microsoft access and sql?

1023

how many ways we can we find the current date using mysql? : Sql dba

1099

What is a pl/sql block?

1225

What do you mean by stored procedures?

1012

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1036

What is the difference between syntax error and runtime error?

1140

What is the use of sql trace?

952

how to install mysql? : Sql dba

1109

What are the advantages of pl sql?

1122

What are pl sql procedures?

1024