Question : I have a query that returns a resultset of three columns, namely SSN,PAID_YEAR and PAID_TOTAL. From this query […]
Tag: cursors
How to improve performance merging multiple table via cursor
Question : I have the following stored procedure to merged multiple tables into 1 table. The records that im tryin […]
Oracle: Get the row count in a cursor when using a OPEN-FOR-USING statement
Question : Within an Oracle procedure, after opening a cursor for a select statement, I fail to find a mean […]
How do database operations (write, update, alter) on particular cell in a table are written to disk without overwriting entire file?
Question : When I want to write to or alter particular cell of an excel file/table using python I’ll use […]
Procedures In Oracle [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Oracle strong ref cursor with dynamic sql
Question : I’m using Oracle 10g. I have a query in a stored procedure that selects entire rows from a […]
Auto increment a value using cursor in SQLServer
Question : I am developing an employee leave management system and My table structure with data is : +———–+———+———-+———-+————+————–+ | […]
Inserting Data using Cursor but check if the data already in the table
Question : I want to check if data already exist in a table before I do an insert using a […]
Stored Proc hangs when no rows exist in cursor? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Search entire database
Question : Recently I was working on the database of an application that had no documentation and the database did […]