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 a table?

569

What is a natural join?

518

What is varray in pl sql?

566

What is difference between group by and partition by?

499

what are the limitations of identity column? : Transact sql

606

What is serial sql?

529

Explain the working of primary key?

612

Why is pl sql needed?

517

How to test for null values?

606

Can delete statement be rollbacked?

527

Why do we go for stored procedures?

516

What is difference between mysql and postgresql?

516

What is the function that is used to transfer a pl/sql table log to a database table?

554

What is trigger in sql?

582

What is %type in sql?

517