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 plpgsql language?

534


What are the methods of filing?

520


what is the difference between primary key and unique key? : Sql dba

531


How to order siblings in oracle hierarchy queries?

600


how to dump a table to a file with 'mysqldump'? : Sql dba

555






what are the different tables present in mysql? : Sql dba

504


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

486


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

508


Can we rollback after truncate?

565


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

673


What is string join?

558


Why do we need pl sql?

550


What are the different type of joins in sql?

544


How do you create a db file?

523


Can we use ddl statements in stored procedure?

696