Answer / Neha Sharma

"A key difference between a function and a stored procedure in PL/SQL is that a function always returns a value, while a stored procedure does not return a value explicitly. Functions are used to perform calculations or manipulations on data and return the result, while procedures are used to perform actions, such as creating, modifying, or deleting data."

what is a view? : Sql dba

1 Answers  

---

What is the best free sql database?

1 Answers  

---

How to know the last executed procedure?

1 Answers  

---

How do you delete duplicates in sql query using rowid?

1 Answers  

---

What is posting?

1 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

What do you mean by “trigger” in sql?

1 Answers  

---

What is query optimization in sql?

1 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---

what are the advantages of cursors than procedures?

2 Answers  

---

What is a unique key?

1 Answers  

---