Question : I’m using an sharded-cluster(Mongo version 2.4.1) with a java application. After a specific time (10 minutes or more) […]
Tag: cursors
Compare two big tables in PL/SQL
Question : I need to implement comparing 2 tables by set of keys (columns of compared tables). By this comparing […]
MySQL cursor always exits out of loop
Question : The cursor query and select value query returns rows if I run it in mysql but when in […]
Internal architecture of cursors
Question : I know that cursor isn’t very good idea, but I have some questions for internal structure of cursor. […]
Cursor Replacement for Newbies
Question : I’d like to know what the general replacement is for a cursor. The general implementation of a cursor […]
Optimization around static cursor use
Question : I’m currently in-house support for a vendor-supplied application which uses static cursors to crawl through a list of […]
Getting two or more column values through a Cursor SQL Server
Question : I have two tables like this: Table Experiment (I will just use one roadID (rID) for now) rID […]
SELECT from Function that return CURSOR
Question : I would like to select from a function that return a SYS_REFCURSOR Type value. for example : CREATE […]
How to reduce the run time of stored procedure by getting rid of cursors?
Question : I have a task of reducing the run time of a stored procedure that runs for hours. Description […]
MySQL Error 1329 – Empty Cursor Issue
Question : I am experiencing an issue with a stored procedure I wrote some time ago that has recently stopped […]