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.
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
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?
There are many properties associated with ActiveX controls, and the properties vary for the type of ________
Fill in the blank(s) with correct word
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?