select regexp_count('hello','l') from dual; or SE

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

Question Posted / mahesh

Answer Posted / mahesh

select regexp_count('hello','l') from dual;

or

SELECT LENGTH('HELLO')-LENGTH(REPLACE('HELLO','L',NULL)) FROM DUAL;

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Do prepared statements prevent sql injection?

897

what are the security recommendations while using mysql? : Sql dba

1049

What has stored procedures in sql and how we can use it?

1014

What is cte?

923

Can ddl statements be used in pl/sql?

1068

What are the types of queries in sql?

1015

what is a database transaction? : Sql dba

1106

What is the difference between jpql and sql?

1022

Can cursors be part of a trigger body?

1586

What is meant by cursor in sql?

941

discuss about myisam key cache. : Sql dba

974

How to write pl sql program in mysql command prompt?

1007

How do you explain an index number?

1022

What does partition by mean in sql?

908

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

944