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

520


How do I restart sql?

511


What is the use of nvl function?

607


Is progress software supports to ( pl/sql )?

517


Why does sql need a server?

554






How do I remove sql plus from windows 10?

560


how can we optimize or increase the speed of a mysql select query? : Sql dba

500


What is pl sql block structure?

533


Write the command to remove all players named sachin from the players table.

721


how to convert character strings to numeric values? : Sql dba

562


Is primary key an index?

527


what is meant by nl2br()? : Sql dba

558


what are the differences between require and include, include_once and require_once? : Sql dba

517


What is auto increment feature in sql?

609


What is native sql query?

540