What is Cursor ?

A  Cursor is a handle ( a name or pointer) for the memory associated with a specific statement.
  • Interview Candidate
  • 2
  • 2449

Showing Answers 1 - 2 of 2 Answers

Culver_lake

  • Mar 28th, 2006
 

A cursor can be viewed as a "Pointer" into the result table of an SQL SELECT statement. Cursors are needed whenever the result contains more than one row.  3rd generation programs like COBOL and C cannot handle more than one row at a time. SQL produces a set-at-a-time. The cursor allows the set to be processed one row-at-a-time, just like a sequential file. COBOL and C are happy, SQL is happy.  I'm happy.

  Was this answer useful?  Yes

aloksourav

  • Mar 31st, 2007
 

cursor is nothing but it is temprary storage area.In other word cursor is a private sql work area whenever issuing sql and pl/sql statements ,it creates a memory area in server.this memory area is know as cursor area.

  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