| Oracle PL / SQL » Cursor » Cursor Fetch |
| 1. | Below is a function that demonstrates how to use the FETCH statement | ||
| 2. | Fetch value from cursor | ||
| 3. | Fetches the records from a cursor variable that returns employee information | ||
| 4. | Fetch cursor to two variables | ||
| 5. | legal and illegal FETCH statements. | ||
| 6. | "ORA-1002: fetch out of sequence" because of the commit inside the SELECT..FOR UPDATE loop. | ||
| 7. | A WHILE cursor fetch loop. | ||
| 8. | Different BULK_COLLECT statements used for bulk binds | ||
| 9. | Check Cursor%FOUND after fetching | ||
| 10. | Fetch value in cursor until NOTFOUND | ||
| 11. | ORA-01002: fetch out of sequence | ||
| 12. | Fetch out cursor value and insert to another table | ||
| 13. | PLS-00394: wrong number of values in the INTO list of a FETCH statement | ||
| 14. | FETCH cursor BULK COLLECT |