Detailed phase of cursor execution
1. The cursor is opened
2. Parse SQL
3. The query is described to know the projection (what columns are going to be
returned, names, datatypes etc.)
4. Bind SQL (Variable Binding)
5. SELECT Query execution
6. Move the record pointer to the first record
FETCH
7. A row of data is fetched
8. The data values from the columns within that row are extracted into the known
projection
9. Step 6 and 7 are repeated until there is no more data or another condition ceases
the fetching
10. The cursor is closed
No comments:
Post a Comment