Question

What is cursor? Explain cursor attributes with example

Answer 1

A movable indicator on a computer screen identifying the point that will be affected by input from the user.Cursor Attributes. Every explicit cursor and cursor variable has four attributes: %FOUND ,%ISOPEN %NOTFOUND , and %ROWCOUNT .Before the first fetch from an open cursor, cursor_name%FOUND returns NULL . Afterward, it returns TRUE if the last fetch returned a row, or FALSE if the last fetch failed to return a row.

Answer 2

Answer:

Each cursor has a set of attributes that enables an application program to test the state of the cursor. These attributes are %ISOPEN, %FOUND, %NOTFOUND, and %ROWCOUNT. %ISOPEN. This attribute is used to determine whether a cursor is in the open state.A cursor is the position indicator on a computer display screen where a user can enter text.