SELECT 'HELLO', INSTR('HELLO','L') AS INSTR F

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

Question Posted / radhesh

Answer Posted / radhesh

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

Is This Answer Correct ?

1 Yes

8 No

Please Help Members By Posting Answers For Below Questions

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1003

what is the bond code in materialized view?

3004

What is varchar used for?

1082

Which join is like an inner join?

1029

How do I add a database to sql?

1128

What are the sql versions?

956

What is the difference between partitioning and sharding?

1008

How many row comparison operators are used while working with a subquery?

1032

how to convert character strings to dates? : Sql dba

1065

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What are the rules to be applied to nulls whilst doing comparisons?

1323

what is self join and what is the requirement of self join? : Sql dba

1145

Is sql between inclusive?

1137

explain the difference between bool, tinyint and bit. : Sql dba

1005

Why do we create views in sql?

1155