What is cursor

Answer Posted / vipin kumar ( m.c.a)

Cursor is a private SQL work area to perform an action using
PL/SQL statement. DBA allocate the memory space to the
objects that is area is called the cursor.
Cursor has two types-
1. Implicit cursor:- means predefine cursor.
2. Explicit cursor:- means created by the user or programmer.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is control file used for?

607


Will you be able to store pictures in the database?

642


What is a database schema in oracle?

625


How many types of segments in Oracle?

531


What is the difference between a primary key & a unique key?

590






Whats the benefit of dbms_stats over analyze?

1497


Explain compound trigger in oracle?

553


What is bulk collect in oracle?

557


How to invoke the original export import utilities?

507


How to create a new user account in oracle?

584


What is Reduced List of Values?

1708


How to get maxsal , minsal, ename department wise in single query

1026


Difference between hot backup vs. Cold backup?

606


What is null value in oracle?

638


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3833