Answer / Ajay Kumar Agrahari

A stored procedure is a set of SQL statements that performs a task, while a stored function returns a single value. Stored procedures can have input parameters, but they don't return a value. On the other hand, stored functions can accept input parameters and return a single scalar value as output.

What is the difference between view and stored procedure?

1 Answers  

---

what are the forced views

6 Answers   Hexaware, TCS,

---

Where the sql database files are stored?

1 Answers  

---

How to pronounce postgresql?

1 Answers  

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

what is overloading procedure or overloading function ?

3 Answers   Genpact,

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---

What is data manipulation language?

1 Answers  

---

What are the ddl commands?

1 Answers  

---

What is materialized view in sql?

1 Answers  

---

Can a foreign key be null?

1 Answers  

---

What is a join query?

1 Answers  

---