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

What is sql key?

1046

What is primary key secondary key alternate key candidate key?

1089

How can we find duplicate records in a table?

996

What are the parameter modes supported by pl/sql?

1154

What are analytical functions in sql?

1080

Explain polymorphism in pl/sql.

1171

Explain dml and ddl?

1059

what is “go” in t-sql? : Transact sql

1158

What are the various levels of constraints?

1170

what are tables and fields? : Sql dba

1105

What are the parts of a basic sql query?

1017

What is linq to sql?

1181

What is trigger point?

1058

What is the most restrictive isolation level? : Transact sql

1128

What is constant in pl sql?

1064