If all the values from a cursor have been fetched and another fetch is issued, the output will be :
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- If all the values from a cursor have been fetched and another fetch is issued,what the output will be?
- What happens when rows are found using a FETCH statement ?
- To use a FETCH staement with a cursor you always have to supply an explicit direction such next or prior.
- When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operati...
- Which of the following statements is incorrect regarding '%FOUND' cursor attribute in PL/SQL?
- Each time you fetch a row from the cursor, it results in a network roundtrip
- "Even for a single fetch from DB2 table, cursor is required in an easytrieve program.". Is the statement true?
- Explicit cursors are used to process multiple row SELECT statements