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

If a cursor is open, how can we find in a pl/sql block?

660


How do I install microsoft sql?

513


What does (+) mean in sql joins?

513


What are the two types of cursors in pl sql?

520


How do I find sql profiler?

499






Why do we need pl sql?

538


What is the use of %rowtype?

524


What are the three pl sql block types?

560


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

537


What are the most important ddl statements in sql?

563


What is an inconsistent dependency?

568


How do you modify a table in sql?

551


How do I order columns in sql?

514


How does an execution block start and end in pl sql?

491


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1996