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

what is difference between delete and truncate commands? : Sql dba

1133

What is memory optimized?

1088

how to load data files into tables with 'mysqlimport'? : Sql dba

1094

Can sql function call stored procedure?

1025

explain the advantages and disadvantages of stored procedure? : Sql dba

1010

Explain spool.

1183

What is break?

1198

What are the different types of constraints?

1187

Is null operator in sql?

1041

What is oracle sql called?

923

What is cross join sql?

918

What are the properties of a transaction?

1128

What is the difference between function and procedure in pl/sql?

1086

what are date and time functions in mysql? : Sql dba

979

What is the difference between the conventional and direct path loads? : aql loader

1400