Database - What is cursor?

What is cursor?

A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.

What is cursor?

A cursor is a variable that represents an area where the result of a query is stored. A single row query is stored in a cursor called ‘implicit cursor’. If a relation that fetches multiple rows, the cursor is called explicit cursor. An explicit cursor is handled in a PL/SQL block and each row can be handled by putting the relation fetched by the cursor, in a loop.
Database - Explain the cursor types
DYNAMIC, STATIC, KEYSET. Implicit Cursor and Explicit Cursor.......
Database - Explain in brief the cursor optimization tips
Close cursor when it is not required, you shouldn’t forget to deallocate cursor after closing it......
Database - What is sub-query?
A query within a query is defined as a sub-query. A sub query is executed by enclosing it within another query....
Post your comment