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

Is clustered index a primary key?

523


which tcp/ip port does sql server run on? : Sql dba

513


what are all the different types of indexes? : Sql dba

524


Why is pl sql needed?

503


what is a table in a database ? : Sql dba

536






What is online transaction processing (oltp)?

600


Define join and name different types of joins?

512


What is an inner join sql?

541


how to write date and time literals? : Sql dba

528


How many triggers can be applied to a table?

595


Which table is left in left join?

516


what is union? : Sql dba

578


Can we rename a column in the output of sql query?

538


What is character functions?

552


what is 'mysqladmin' in mysql? : Sql dba

527