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 vector point function?

1026

List and explain the different types of join clauses supported in ansi-standard sql?

1344

explain primary keys and auto increment fields in mysql : sql dba

949

Explain the difference in execution of triggers and stored procedures?

1001

How many functions are there in sql?

999

Is not null in sql?

966

How to run sql*plus commands in sql developer?

1133

What is a procedure in pl sql?

1194

Explain the difference between drop and truncate commands in sql?

1022

How do sql triggers work?

1022

How do I debug a stored procedure?

1095

How many triggers can be applied on a table?

923

What are inner and outer joins examples of both?

940

Is sql considered coding?

1027

what is primary key? : Sql dba

1009