What is a cursor?

Oracle uses work area to execute SQL statements and store processing information PL/SQL construct called a cursor lets you name a work area and access its stored information A cursor is a mechanism used to fetch more than one row in a Pl/SQl block.

Interview Candidate
Aug 29th, 2004
7
3914

SQL

Answer

Showing Answers 1 - 7 of 7 Answers

aditi

May 24th, 2006

cursor is basically used when a select stmt returns multiple rows.

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 12th, 2006

cursor is a private sql working area.
cursor could be two type implicit or explicit cursor
only explicit cursor are assigned private sql working area.

syam sundar

Aug 17th, 2007

Oracle ueses the private area for excute SQL statements and store processing information. The private area is called as CONTEXT AREA

CURSOR: cursor is a handle or pointer to the context area.