CodeSnip: How to make use of parameterized cursor in Oracle
April 26, 2008 – 3:00 pmCodeSnip: How to make use of parameterized cursor in Oracle
Often it is convenient to pass a given set of values as input parameter to a cursor. It is very useful where nested cursors are used. Parameterizing the cursor makes it more usable and avoids the limitation of hard coding values in where the clause. In this code snippet, Deepankar examines this technique with the help of the relevant SQL code. He also provides a brief analysis of the code and also a screenshot of the final output.
Deepankar Sarangi
Need Help ASAP PLEASE PLEASE HELP!
hey all, first post, im a real n00b at this.. its just part of my first yr at uni and dont even need it for the 2nd yr and never done it before.. its such a small part of my coursework and all it does is get me a D grade.. got 4 parts after this that i can do myself but this part is killing…
You must be logged in to post a comment.