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

Answer Posted / kuldeep123

select regexp_count('HEllO','L') from dual;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need cursor in pl sql?

754


What are secondary keys?

655


What is difference between rank () row_number () and dense_rank () in sql?

685


What mean sql?

665


How do you declare a variable in pl sql?

632






What is primary key and unique key?

647


How much does a sql dba make? : SQL DBA

600


Why stored procedure is better than query?

605


Does sql view stored data?

638


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2178


How many sql databases can you have on one server?

671


What is the syntax to add a record to a table?

662


Is sqlite thread safe?

692


What are views in sql?

640


What is basic structure of pl sql?

592