SQL - What is a cursor?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 30 of 171

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.

Total Answers and Comments: 3

Last Update: August 17, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 24, 2006 08:26:39

aditi

RE: What is a cursor?

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

Is this answer useful? Yes | No

December 12, 2006 09:15:21

rampratap409

Member Since: September 2006 Contribution: 111

RE: What is a cursor?

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.

Is this answer useful? Yes | No

August 17, 2007 08:30:50

syam sundar

RE: What is a cursor?

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank