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 record variable?

1002

What is pl sql commands?

1054

What is meant by <> in sql?

984

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1011

What is the difference between drop and truncate commands?

1074

What are the two types of periodical indexes?

943

What does inner join mean?

1185

How to get list of all tables from a database?

1165

How do you optimize a query?

1016

Why is %isopen always false for an implicit cursor?

1120

can sql servers linked to other servers like oracle? : Sql dba

1014

How many developers work on postgresql?

990

what are the features and advantages of object-oriented programming? : Sql dba

1026

What is error ora-12154: tns:could not resolve the connect identifier specified?

1090

How can I tell if sql is running?

1076