In PL/SQL what is a Cursor? When do we use an explicit Cursor? What do you do when you declare a Cursor?
What will be an ideal response?
A cursor is a PL/SQL construct that lets you name a work area and access its
stored information.
We declare an explicit cursor for queries that returns more than one row so that
we can process the rows individually.
When we declare an explicit cursor we name it and associate it with a specific
query.
You might also like to view...
The ____ data type is used to store long passages of data containing text and alphanumeric characters.
A. Long Text B. Lookup C. AutoNumber D. OLE Object
Which of the following statement about layers of the TCP/IP protocol stack is false?
a) Each layer provides functionality for the layers above it. b) Layers ease the development, debugging and maintenance of network applications. c) Each layer can be implemented by following one or more protocols. d) Each layer can be used independently to perform network communication.
One thing you should always try to include in a Search feature is:
a. Fancy wording b. Instructions c. The word “search” or a search icon (magnifying glass) d. Options for limiting the scope of the search
In the accompanying figure, Item 3 points to the Custom Animation tab, which displays a list of the animation effects added to the ____ in the order they will animate.
A. Toolbox B. selected slide C. Entrance Effects Gallery D. Notes pane