Answer / tulsi

A cursor declared in a package specification is global and
can be accessed by other procedures or procedures in a
package.
A cursor declared in a procedure is local to the procedure
that can not be accessed by other procedures.

Answer / ratan singh sengar

SP is a set of SQL Statements that resides in server. Advantage of SP is just that it is pre compiled and available in the server. So, whenever this SP is called, its executed instantly since its already been compiled. This makes the faster performance while executing the SP.
cursor:
Cursors are add on feature of SP , for row by row validations.
For instance : You have a list of employees belong to various department. For calculating the bonus % which varies for department to department, you use cursors to calculate Bonus.

How to call a javascript function from pl sql?

0 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

What are different types of queries in sql?

0 Answers  

---

Can we join two tables without common column?

0 Answers  

---

What are dml commands?

0 Answers  

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

what is sql.

7 Answers   Ericsson, Hewitt,

---

Why triggers are used?

0 Answers  

---

what are all the different normalizations? : Sql dba

0 Answers  

---

What is a database? Explain

0 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---