![]() When a cursor is opened, rows can be fetched from the cursor one by one or in a block to do data manipulation. The following steps are involced in a SQL cursor life cycle.Ī cursor is declared by defining the SQL statement.Ī cursor is opened for storing data retrieved from the result set. In this article, we will learn the following: This article explains everything about SQL cursors. A SQL cursor is used when the data needs to be updated row by row. A SQL cursor is a database object that is used to retrieve data from a result set one row at a time.
0 Comments
Leave a Reply. |