A cursor that is defined so that one or more rows can be returned as a rowset for a single FETCH statement and the cursor is positioned on the set of rows that is fetched.