Answer Posted / kuldeep123

select regexp_count('HEllO','L') from dual;

How to create a menu in sqlplus or pl/sql?

606

---

Why is the cursor important?

535

---

Is a secondary key the same as a foreign key?

486

---

Can we create foreign key without primary key?

530

---

What is pl sql commands?

553

---

---

Explain what is a view?

590

---

How do I debug a stored procedure?

625

---

Is left join faster than inner join?

609

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

574

---

What is data type in database?

539

---

How do you explain an index number?

531

---

Explain how to use transactions efficiently : transact sql

523

---

What is the difference between a procedure and a function?

488

---

What is pl sql code?

585

---

What are functions in sql?

504

---