![]() ![]() In relational databases, operations are made on a set of rows. The cursor should be closed explicitly after data manipulation.Ĭursors should be deallocated to delete cursor definition and released all the system resources associated with the cursor. ![]() When a cursor is opened, rows can be fetched from the cursor one by one or in a block to do data manipulation. A cursor is a database object which is used to retrieve data from resultset one row at a time.The cursor can be used when the data needs to be updated row by row.Ī cursor is declared by defining the SQL statement.Ī cursor is opened for storing data retrieved from the result set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |