What are four cursor attributes? State their use.

What will be an ideal response?


%ISOPEN it returns TRUE if the cursor is open, otherwise it returns FALSE.
%FOUND it returns TRUE if the last fetch returned a row, otherwise it returns

FALSE.

%NOTFOUND it returns TRUE if the last fetch did not return a row, otherwise it

returns FALSE. It complements %FOUND attribute.

%ROWCOUNT it returns total number of rows returned.

Computer Science & Information Technology

You might also like to view...

You are designing a loop that is to exit only if the values of both x and y are 0. Which of the following would you use for your loop repetition condition?

a. x != 0 && y != 0 b. x != 0 || y != 0 c. !(x != 0) || !(y != 0) d. x == 0 && y != 0

Computer Science & Information Technology

The Tiger schedule is potentially a large data structure that changes frequently, but each cub needs an up-to-date representation of the portions it is currently handling. Suggest a mechanism for the distribution of the schedule to the cubs

What will be an ideal response?

Computer Science & Information Technology

There are many properties associated with ActiveX controls, and the properties vary for the type of ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

White circles that display on the sides and corners of a placeholder; enables the user to adjust the height and width of the object.

What will be an ideal response?

Computer Science & Information Technology