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

What is varchar used for?

745


What are the various levels of constraints?

853


What does t sql mean?

702


What is the difference between mdf and ndf files?

775


Is sql port 1433 encrypted?

776






Does pl/sql support create command?

737


How much does sql cost?

733


How do I partition a table in sql?

728


Is join and inner join the same?

722


Explain the significance of the & and && operators in pl sql.

743


How to create your own reports in sql developer?

729


What is the need of merge statement?

756


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

709


Can we insert in view in sql?

774


What is asqueryable?

710