What is the difference between an explicit and an implicit cursor?
What will be an ideal response?
Implicit cursorsare declared automatically for all DML and SELECT statements issued within a PL/SQL block. Explicit cursors on the other hand,are declared and manipulated in the PL/SQL block code for handling a set of rows returned by a SELECT statement.
You might also like to view...
Forms of alternative media programs include the following, except:
A) buzz marketing B) online marketing C) product placement D) guerilla marketing
Tangibles, reliability, responsiveness, assurance, and empathy are the five dimensions of service quality used in which of the following?
A) total quality management (TQM) B) SERVQUAL C) gap analysis D) the critical incident technique E) the market fulfillment approach
Your project team is interested in determining an overall risk factor for your project to develop a personal submarine constructed entirely of Popsicle sticks and wood glue
Describe how you would develop reasonable estimates for each of the probability of failure categories and each of the consequence of failure categories.
When appropriate, the optimal solution to a maximization linear programming problem can be found by graphing the feasible region and
A) finding the profit at every corner point of the feasible region to see which one gives the highest value. B) moving the isoprofit lines towards the origin in a parallel fashion until the last point in the feasible region is encountered. C) locating the point that is highest on the graph. D) None of the above E) All of the above