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

how to use case expression? : Sql dba

729

How to run pl sql program in mysql?

676

what is 'trigger' in sql? : Sql dba

721

Explain what is a view?

790

What is the difference between pl and sql?

729

What do you mean by field in sql?

776

What are the set operators in sql?

768

What pl/sql package consists of?

831

Can we create a trigger on view?

662

what is meant by urlencode and urldocode? : Sql dba

765

what are the different index configurations a table can have? : Sql dba

739

How do I save a stored procedure?

725

Is join an inner join?

709

What is the sql case statement?

743

What is procedure and function?

675