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

919

---

Explain about the return statement?

944

---

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

910

---

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

893

---

Where the procedures are stored in database?

903

---

Explain about the implementation of stored procedures?

934

---

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

1173

---

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

785

---

How can we call stored procedures inside store procedures?

883

---

State about the security aspects of stored procedures?

1031

---

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

990

---

How one call ddl statement using stored procedures in oracle?

852

---

State the different extensions for stored procedures?

868

---

How many types of stored procedure?

912

---

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

872

---