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 do I pipe the output of one isql to another?

0 Answers  

---

what is a database transaction? : Sql dba

0 Answers  

---

How to read/write files from pl/sql?

0 Answers  

---

What is sql profiler in oracle?

0 Answers  

---

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

what is the use of set statement in tsql? : Transact sql

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

what is a stored procedure? : Sql dba

0 Answers  

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

How do you run a query?

0 Answers  

---