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 are set operators in sql? : Sql dba

1108

Do ddl statements need commit?

1024

What does sql stand for?

1056

what are ddl statements in mysql? : Sql dba

1269

how to include comments in sql statements? : Sql dba

999

Can we use pl sql in mysql?

1063

What is varchar sql?

1208

Why do we use sqlite?

1029

What is dba in sql? : SQL DBA

1095

List the various privileges that a user can grant to another user?

1094

Is pl sql better than sql?

1089

What is AUTH_ID and AUTH_USER in pl/sql ?

2237

What are some predefined exceptions in pl/sql?

1226

What is offset in sql query?

1177

how is exception handling handled in mysql? : Sql dba

1132