When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- To use a FETCH staement with a cursor you always have to supply an explicit direction such next or prior.
- What happens when rows are found using a FETCH statement ?
- Which of the following operations in SQL retrieves the rows from the active set, one row at a time?
- When dealing with Cursor For Loops, which steps are taken care of implicitly? Choose all that apply
- If all the values from a cursor have been fetched and another fetch is issued,what the output will be?
- "Even for a single fetch from DB2 table, cursor is required in an easytrieve program.". Is the statement true?
- CURSOR FOR loop can be opened with the command...
- What does the cursor attribute ‘%rowcount’ do?