There are two types of cursors in PL/SQL: These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed.
They are also created when a SELECT statement that returns just one row is executed.
Since you know the data in this column, you can set the fill factor to 100% to get the best read times.basis -- and I want to add my name to the list of people who wish cursors had never been introduced. Problems with cursors include extending locks, their inability to cache execution plans and CPU/RAM overhead.Many T-SQL programmers and DBAs do not know how to successfully loop over records without the need for cursors.· If you are fetching a cursor to a list of variables, the variables should be listed in the same order in the fetch statement as the columns are present in the cursor.General Form of using an explicit cursor is: In the above example, first we are creating a record ‘emp_rec’ of the same structure as of table ‘emp_tbl’ in line no 2.It is created on a SELECT Statement which returns more than one row. General Syntax for creating a cursor is as given below: In the above example we are creating a cursor ‘emp_cur’ on a query which returns the records of all the employees with salary greater than 5000. When the data is fetched it is copied to the record or variables and the logical pointer moves to the next row and it becomes the current row.