SELECT LENGTH(REPLACE(TRANSLATE('HELLO','HEO',' &#

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

Question Posted / ansupriya

Answer Posted / ansupriya

SELECT LENGTH(REPLACE(TRANSLATE('HELLO','HEO',' '),' ')) FROM DUAL

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the benefits of pl sql?

518

Is subquery faster than join?

562

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

804

What is a constraint?

557

What is sql and also describe types of sql statements?

553

Is sql port 1433 encrypted?

564

Why do we create stored procedures & functions in pl/sql and how are they different?

498

What is procedure and function?

507

How do you optimize a stored procedure query?

559

Is it possible to create startup or shutdown trigger for on-schema?

577

Give the order of sql select?

601

How do I debug a stored procedure?

617

What is primary key and foreign key with example?

486

How is a process of pl/sql compiled?

589

how can you create an empty table from an existing table? : Sql dba

652