Use this tag for programming-related questions about database cursors.
I have a dynamic SQL statement I've created in a stored procedure. I need to iterate over the results using …
tsql stored-procedures dynamic-sql database-cursorI want to use a database cursor; first I need to understand what its use and syntax are, and in …
sql-server database-cursorI have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I …
oracle plsql toad database-cursor ora-00932Is there a way to perform a Cursor For Loop with an dynamic SQL-statement? If I don't want to declare …
oracle dynamic plsql database-cursorUsing SQL 2005 / 2008 I have to use a forward cursor, but I don't want to suffer poor performance. Is there a …
sql-server tsql sql-server-2008 sql-server-2005 database-cursorAs in the topic. Can I simply reset cursor's position to the beginning in Transact-SQL, so it can run again …
sql-server tsql database-cursorI have read a book whose title is "Oracle PL SQL Programming" (2nd ed.) by Steven Feuerstein & Bill Pribyl. …
oracle plsql database-cursorI don't understand the meaning of following lines: WHILE 1 = 1 BEGIN FETCH NEXT FROM SomeCursor INTO @SomeId, @SomeOtherColumn IF @@FETCH_STATUS &…
sql sql-server tsql database-cursorBasically I would like to pass a date value to a cursor, and print out the entire row/record after …
oracle plsql database-cursorI perform the following sequence of steps(step-wise using F-9) in Oracle SQL Developer: create database link mydb connect to …
sql oracle database-connection database-link database-cursor