Oracle Cursor
Cursor are pointers and they point to one row at time. Data is on PGA where a private area is created with the name of cursor.
Cursor give us better control over the data, as we can iterate data row by row.
Type of cursor
1. Implicit Cursor - managed by oracle, user cannot control that
2. Explicit Cursor - user defined
Cursor are pointers and they point to one row at time. Data is on PGA where a private area is created with the name of cursor.
Cursor give us better control over the data, as we can iterate data row by row.
Type of cursor
1. Implicit Cursor - managed by oracle, user cannot control that
2. Explicit Cursor - user defined
No comments:
Post a Comment