Cursor overview

When OceanBase Database executes an SQL statement, it saves the result set and processing information in an unnamed private memory area and sets a pointer to the start of this memory area. This pointer is the cursor.

You can use a cursor to retrieve one record at a time. The cursor attributes return the status information of the cursor. Cursors are divided into explicit and implicit cursors.