Which of the following statements hold true for a cursor?

Options
- Specify positioning at specific rows in the result set
- Retrieve multiple columns based on the current result set position
- Modify data in the rows at the current position in the result set
- Both a and c

CORRECT ANSWER : Both a and c

Discussion Board
Cursor

A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it. It specifies positioning at specific rows in the result set. It modifies data in the rows at the current position in the result set.

Prajakta Pandit 02-9-2017 04:47 AM

Hi Francisco

Cursor is also used to update the data using "where current of". Please check ora documentation.

shrikant yadav 09-22-2014 02:57 AM

I don't undestand how modify the data

I don't understand, how the cursor modify the data?

Please advice.

Thanks
Francisco Banda

Francisco Banda 08-9-2014 03:01 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲