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 primary key secondary key alternate key candidate key?

1016

How can we avoid duplicating records in a query?

958

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1035

Can we change the table name in sql?

925

explain commit and rollback in mysql : sql dba

994

What are basic techniques of indexing?

1360

What is cursor status?

1176

How to start the command-line sql*plus?

1040

What are different joins used in sql?

1044

Which is better varchar or nvarchar?

976

how can we optimize or increase the speed of a mysql select query? : Sql dba

923

How do I install sql?

974

What is the use of sql trace?

936

What is an exception in pl/sql?

1054

What are character functions in sql?

920