Oracle Cursors in Pl/SQL

Why we use cursor in plsql? in same case can we use cursor or procedure?? difference between cursor , procedure and package?? is any relation between 3??

Showing Answers 1 - 3 of 3 Answers


  • Nov 14th, 2014

We use cursors so that we can reduce the number of concurrent acess to the db

  Was this answer useful?  Yes


  • Nov 14th, 2014

Cursor in Plsql: When we execute sql query. The records fetched from sql query, information about sql query is stored in context memory area in oracle. so in order to access each record row by row we use cursors.

Procedure: A subprogram is program unit / module that performs a particular task these sub-programs are combined to form larger program.

Yes we can use cursors in procedure.

Package consists of multiple functions or procedures.

  Was this answer useful?  Yes

parul priya

  • Nov 20th, 2014

we use cursor when we need to handle multiple rows query in plsql.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions