Answer Posted / syam

Hi Shailesh,


let me know that how can i improve performence of
procedures by useing indexes

What is a stored procedure in sql with example?

598

---

Why we use stored procedure instead of query?

530

---

Where is pl sql used?

514

---

Can we create view in stored procedure?

521

---

How do you create an update query?

517

---

---

How do I send sql query results to excel?

577

---

What is union and union all keyword in sql?

563

---

Why do we use subquery?

483

---

Explain the difference between sql and mysql.

563

---

Is a table valued function object?

575

---

what is the difference between $message and $$message? : Sql dba

543

---

Which one is faster ienumerable or iqueryable?

480

---

Why do we use cursors?

507

---

What is the command used to fetch first 5 characters of the string?

878

---

How long it takes to learn pl sql?

531

---