When is the results table for the query in a DECLARE CURSOR statement created?
9 August 2009
76 views
No Comment
(No Ratings Yet)
Loading ...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
- 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?
- What is read-only cursor?
- when does the sql statement gets executed when you use cursor in the application programming ?
- 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?
- What information can you find in SYSIBM.SYSLINKS table?
Leave your response!
You must be logged in to post a comment.