Answer Posted / mahesh

select regexp_count('hello','l') from dual;

or

SELECT LENGTH('HELLO')-LENGTH(REPLACE('HELLO','L',NULL)) FROM DUAL;

how to create a table index in mysql? : Sql dba

582

---

Which command is used to call a stored procedure?

485

---

What is the difference between having and a where in sql?

561

---

How do sql triggers work?

536

---

What is PL/SQL Records?

612

---

---

What is offset and limit in sql?

539

---

Explain cursor types?

567

---

What are different joins used in sql?

545

---

What are the datatypes available in pl/sql ?

597

---

What is database white box testing and black box testing?

624

---

What is an ndf file?

515

---

What is sharding in sql?

548

---

What are the types of join and explain each?

567

---

What is a primary key? Explain

528

---

When you have to use a default "rollback to" savepoint of plvlog?

704

---