When is the results table for the query in a DECLARE CURSOR statement created?
9 August 2009
296 views
No Comment
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement.
Popularity: unranked [?]
Related interview questions
- when does the sql statement gets executed when you use cursor in the application programming ?
- What is read-only cursor?
- What is the syntax required for the creation of a cursor?
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
- Can we declare DB2 HOST variable in COBOL COPY book?











Leave your response!
You must be logged in to post a comment.