What is the difference between a user defined function and a stored procedure?

866

---

Explain about the return statement?

876

---

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

841

---

What are external procedures ? Why and when they are used?

845

---

Where the procedures are stored in database?

844

---

Explain about the implementation of stored procedures?

877

---

Does storing of data in stored procedures increase the access time? Explain?

1116

---

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

718

---

How can we call stored procedures inside store procedures?

826

---

State about the security aspects of stored procedures?

976

---

Explain the benefits of running stored procedure on a database engine?

938

---

How one call ddl statement using stored procedures in oracle?

799

---

State the different extensions for stored procedures?

800

---

How many types of stored procedure?

848

---

What is the difference between "is" and "as" while creating procedure?

808

---