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

Answer Posted / radhesh

SELECT 'HELLO', INSTR('HELLO','L') AS INSTR FROM dual;

Is This Answer Correct ?    1 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does view store data in sql?

535


How many sql core licenses do I need?

509


How do I sort a table in sql?

598


How does one load ebcdic data? : aql loader

654


Is inner join faster than left join?

636






how to show all tables with 'mysql'? : Sql dba

610


Why partition by is used in sql?

556


What are the different types of tables in sql?

486


How to read/write files from pl/sql?

582


What is memory optimized?

556


What is the process of debugging?

555


What is not in sql?

500


Explain the purpose of %type and %rowtype data types?

503


How to run sql statements with oracle sql developer?

625


How is data stored on a disk?

541