Re: dynamically alloc cursur vs. local,gloab cursor
Posted by:
Rick James
Date: August 02, 2016 06:38PM
When I here of someone asking about SQL Cursors, I envision a programmer who has not learned the power of SQL.
Most (not all) uses of Cursors can be eliminated by formulating a single SQL that does all the work "all at once" rather than iterating through code.
If you would like to show use the SQL loop, and SHOW CREATE TABLE, we may be able to help you make it better -- thereby obviating the questions you posed.
Subject
Views
Written By
Posted
4011
July 25, 2016 09:02AM
848
August 01, 2016 07:22AM
Re: dynamically alloc cursur vs. local,gloab cursor
870
August 02, 2016 06:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.